dotnetwarriors.com

Creating database in SQL Server 2008 R2

Jul 20, 2018 Sql Server 29
In this article i will explain how to create database and tables in sql server 2008 R2 .

there are some simple steps to learn that how to create database and tables in sql server.

 

Step 1:- Open SQL Server management Studio,

then a new popup window will display as below image:

Select Authentication Type Windows/Sql Authentication, and click on connect button.

Creating database in SQL Server 2008 R2

Step 2:- below image shows the Sql server main window, Click on New Query and write the query to create the new database and click on Execute

Creating database in SQL Server 2008 R2

Step 3:- If there are more than one database and you want to create a new table in a database then you have the need to execute the below query first to select the appropriate database as below image.

Creating database in SQL Server 2008 R2

After the use databaseName query you can execute the create, insert/Update/Delete table query.

 





Share This Article :

Comments


Add Comment


 
Security Code :
18 + 4 =