| title | Work with Tables in Database Diagram (Visual Database Tools) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/13/2017 | ||||
| ms.prod | sql-server-2014 | ||||
| ms.reviewer | |||||
| ms.technology | ssms | ||||
| ms.topic | conceptual | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | ee2c5d84-22bf-4597-ac70-a27ed8cc94f4 | ||||
| author | stevestein | ||||
| ms.author | sstein | ||||
| manager | craigg |
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.
Add Tables to Diagrams (Visual Database Tools)
Add Related Tables to Diagrams (Visual Database Tools)
Save Selected Tables on a Diagram (Visual Database Tools)
Copy Tables from One Database Diagrams to Another (Visual Database Tools)
Remove Tables from Database Diagrams (Visual Database Tools)
Map Many-to-Many Relationships (Visual Database Tools)
Draw Reflexive Relationships (Visual Database Tools)
Add Table Dialog Box (Database Designer) (Visual Database Tools)