sql-create-database

 SQL consists of a data definition language, data manipulation language and data control language.
 The scope of SQL Server includes data insert, query, update and delete, schema creation and modification, and data access control.

SQL Server Database contains groups of many objects like table, query, stored procedure, function, trigger etc. we can store schema and data in database. schema means declarative syntax to define fields and data types. 

Create a Database

From the Windows Start Menu --> select “Microsoft SQL Server”--> Click on “SQL Server Management Studio”.

 Once the Management Studio starts -> Select Server Name( that is your pc name example: abc-PC, xyz-PC) and then select Login and enter password. the database is open.

 

 

In left side of the database there is Object Explorer. In Object Explorer the menu contains Database, Security, Server Objects, Replication and Management.

 

 

Right click the Databases folder and select new Database. Enter a name in the “Database name” text box. For this example, well use the name “TestDB”.

Finally database shows below

SQL CREATE DATABASE Statement Through sql-query

Create Database Syntax

CREATE DATABASE TestDatabaseName;

Create Database Example

write sql query on query window and click Execute 

CREATE DATABASE Test_DB;