When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to delete a database diagram, they should follow the next steps:
1. In Object Explorer, expand the Database Diagrams folder.
2. Right-click the database diagram that they want to delete.
3. Choose Delete on the shortcut menu.
4. A message prompts them to confirm the deletion. Choose Yes.
The database diagram is deleted from the database. When developers delete a database diagram, the tables in the diagram are not deleted.