How to Create new database in SQL -Server Management Studio.?

 Create new database in SQL -Server

 

  • Open the SQL-Server Management Studio 2005 from the Programs File.
  • Click on Connect Button to Open the Database. 
  • Right Click on the Database to Create a New Database.
  • Enter the Database name which you want to create. 
  • Then click OK button to Create New Database.
  •  After creating New Database you will have a below screen. 
  • Select the Database and select Table Tab to create new Table.

  •  For Creating New Table, Right click on the Table Tab and select New Table.

 

  • After this option you need to create column name which you want to create in your Table.

 


  • Before, creating a New Table, you will have to create a column for that Table.

 

  • Enter the Column name with Data Type, and then save the Table.

 

  • After doing this, you will have a Table.

 

  • For Showing the Table Data, Right Click on Table and click on the Open Table.

 

  • For Create New Stored Procedure go to Programmatically and then select Stored Procedure Tab.
  • I Hope, it will be helpful to you.

Leave a Reply

Your email address will not be published. Required fields are marked *

7 + 4 =


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">