How to create Database and Table in Sql Server? - ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF snippets and tutorial

How to create Database and Table in Sql Server?

Introduction: In this I will explain how to create Database and Table in Sql Server.
  1.  Open Sql Server. Select Authentication and click on Connect.
  2.           Right click on Database>New Database.

  3.          Enter Database name.

    Here TEST is Database and click on Ok.

    Now go to Database and click. You see Database of TEST.

    4.     Click on Database TEST. You see Database Diagrams,Table, Views,Synonyms, Programmability, Service Broker, Storage and Security.

    5.     To create Table, right click on Tables.
    New window will be open.

    6.      Enter Table fields and set Table ID auto increment. To set ID auto increment go to Identity specification and do it true.

    7.   Now save the Table.

    Now you see the STUDENT_DETAIL table in tables.

    Is it helpful?

    If yes post your comment to admire my work. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.