{"id":64,"date":"2016-05-18T00:21:06","date_gmt":"2016-05-18T07:21:06","guid":{"rendered":"https:\/\/database.guide\/?p=64"},"modified":"2020-02-14T16:35:18","modified_gmt":"2020-02-14T23:35:18","slug":"how-to-create-a-table-in-sql-server","status":"publish","type":"post","link":"https:\/\/database.guide\/how-to-create-a-table-in-sql-server\/","title":{"rendered":"How to Create a Table in SQL Server"},"content":{"rendered":"

To create a table\u00a0in\u00a0SQL Server<\/a> using the GUI:<\/p>\n

    \n
  1. Ensuring that\u00a0the right database is expanded in Object Explorer,\u00a0right click on the Tables<\/samp><\/kbd> icon and select Table...<\/samp><\/kbd> from the contextual menu<\/li>\n
  2. A new table will open in Design view. Add the columns, their data types, and column properties.<\/li>\n
  3. Save the table (either from the File menu, or by right-clicking on the table tab and selecting Save Table1<\/kbd>)<\/li>\n<\/ol>\n

    The table will appear in the Object Explorer\u00a0under the Tables<\/samp><\/kbd> icon for the applicable database.<\/p>\n

    <\/p>\n

    Below are screenshots for the above steps.<\/p>\n

    Right-Click on “Tables”<\/h2>\n

    Ensuring that\u00a0the right database is expanded in Object Explorer,\u00a0right click on the Tables<\/samp><\/kbd> icon and select Table...<\/samp><\/kbd> from the contextual menu:<\/p>\n

    \"Screenshot<\/a>
    Right-clicking on “Tables” brings up the contextual menu. To create a new table, click “Table…”<\/figcaption><\/figure>\n

    The New Table in Design View<\/h2>\n

    A new table will open in Design view. Add the columns, their data types, and column properties:<\/p>\n

    \"Screenshot<\/a>
    A new table in Design view after some columns have been added. Clicking in a column name in the top pane will display its properties in the bottom pane. Modify these as required or leave them at the default values.<\/figcaption><\/figure>\n

    Save the Table<\/h2>\n

    Save the table (either from the File menu, or by right-clicking on the table tab and selecting Save Table_1<\/kbd>):<\/p>\n

    \"Screenshot<\/a>
    Right-clicking on the table’s tab will present the “Save…” option.<\/figcaption><\/figure>\n

    Name the table at the prompt and your table will be added to the database.<\/p>\n

    Check the New Table<\/h2>\n

    It’s good practice\u00a0to check that the table has been created in the correct database and has all the correct columns and data types.<\/p>\n

    You\u00a0will be able to see the new table\u00a0in the\u00a0Object Explorer.\u00a0If you can’t immediately see the new table in the Object Explorer, right click on Tables<\/kbd> and click Refresh<\/kbd>:<\/p>\n

    \"Screenshot<\/a>
    You may need to refresh the table list before you see the new table in the Object Explorer.<\/figcaption><\/figure>\n

     <\/p>\n

    When you can see the table in the Object Explorer, expand it to reveal all the columns and their respective data types:<\/p>\n

    \"Screenshot<\/a>
    Expanding a table in the Object Explorer displays the table’s columns.<\/figcaption><\/figure>\n

    Create a Table using a Query<\/h2>\n

    You can also create a table using a query<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    To create a table\u00a0in\u00a0SQL Server using the GUI: Ensuring that\u00a0the right database is expanded in Object Explorer,\u00a0right click on the Tables icon and select Table… from the contextual menu A new table will open in Design view. Add the columns, their data types, and column properties. Save the table (either from the File menu, or … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[9,10,12],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-create-table","tag-how-to","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":10,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"predecessor-version":[{"id":732,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/64\/revisions\/732"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}