How to create a table in Microsoft SQL Server

Home > Search > How-to
  by

  1. In SQL Server, expand Databases
  2. Expand the database being used, right click on Tables, and select Tables...
  3. Create the Table columns
    • For the id column, to set id as the primary key, right click on the column and select primary key
    • To auto-increment the id column, left click to select the id column, and in column properties, change Identity Specification (Is Identity) from No to Yes
  4. File -> Save As
  5. Right click on Tables and select Refresh. The new table should now show.


Add a Comment




We will never share your name or email with anyone. Enter your email if you would like to be notified when we respond to your comment.




Please enter in the box below so that we can be sure you are a human.




Comments