Create and update database tables

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

The Table Designer is a visual tool where you design and visualize database tables. Use the SQL Server Management Studio (SSMS) Table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints.

Create a table

  1. Right-click the Tables node in your database and select New > Table:

    New table

  2. Add columns to your table:

    design table

  3. Close the designer and save your changes.

Update a table

  1. Right-click the table under the Tables node of your database and select Design:

    Update table

  2. Update the desired table settings:

  3. Close the designer and save your changes.

See Also

Tables
Table Properties (Visual Database Tools)
Column Properties
Add Columns to a Table
Primary and Foreign Keys
Indexes
Data types (Transact-SQL)
Download SQL Server Management Studio (SSMS)
Create a database and add tables in Visual Studio