title

Work with Tables in Database Diagram

ms.prod

sql

ms.prod_service

sql-tools

ms.technology

ssms

ms.topic

conceptual

helpviewer_keywords

database diagrams [SQL Server], tables

Table Designer, database diagrams

tables [SQL Server], database diagrams

database diagrams [SQL Server], Table Designer

ms.assetid

ee2c5d84-22bf-4597-ac70-a27ed8cc94f4

author

markingmyname

ms.author

maghan

ms.manager

jroth

ms.reviewer

ms.custom

seo-lt-2019

ms.date

01/19/2017

Work with Tables in Database Diagram (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] You can modify and create database tables in either Table Designer or Database Diagram Designer.

Note

If the table is published for replication, you must make schema changes using the Transact-SQL statement ALTER TABLE or SQL Server Management Objects (SMO). When schema changes are made using the Table Designer or the Database Diagram Designer, it attempts to drop and recreate the table. You cannot drop published objects, therefore the schema change will fail.