SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

I opened SQL Server Enterprise Manager, created a new diagram, added my tables, created a number of relationships, and went to save it.

You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.

Fortunately, there are database development tools that can generate correct SQL queries for you, often by dragging and dropping tables and fields from the schema diagram into a query diagram.