How to export a diagram in SQL Server?

In SQL Server Management Studio, you can use database diagrams to export a visual representation of the database structure. Here are the specific steps:

1. Open SQL Server Management Studio and connect to the database from which you want to export the schema diagram.
2. In the Object Explorer, expand the database node, then right-click on the “Database Diagrams” node, and select “New Database Diagram”.
3. In the “Add Table” dialog box that appears, select the table you want to export the structure diagram for, and then click the “Add” button. You can continue to add other objects such as views and stored procedures.
4. Click on the “Close” button, and then choose “Save” in the pop-up dialog box to save the database diagram.
5. After saving the database diagram, you can export the structure of the database using the “Generate Script” feature. Right-click on the database diagram, select “Generate Script,” choose the objects and options you want to generate a script for, and finally click the “Generate Script” button.
6. In the generate script wizard, choose the file format you want to export the schema diagram to (e.g. SQL script), then click the “Finish” button.

By following the above steps, you can export a structure diagram of the SQL Server database.