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;
