design-tables-visual-database-tools.md

title	Create and Update Tables
ms.custom	seo-lt-2019
ms.date	08/25/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	Visual Database Tools [SQL Server], Table Designer Table Designer, designing tables opening tables opening Table Designer tables [SQL Server], opening Table Designer, opening
ms.assetid	c49e0155-5dcb-481f-9538-e1bde77105e2
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Create and update database tables

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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:

   

2. Add columns to your 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:

   

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