How to generate database schema for an exiting database in MSSQL?

Question

Please help me letting know how to create a database schema for an existing database in mssql, could this be done through Microsoft SQL Server Management Studio Express?

My Boss has asked me generate a database schema for a database of an existing application.

Answer 1

Yes, this can absolutely be done.

In Management Studio, expand the database. You'll see a folder option called "Database Diagrams":

Expand that, and in case there's nothing present yet, you'll be presented with a dialogue asking whether you want to create a new diagram:

Should that not work for some reason, you can right-click the same Database Diagrams folder, and select "New Database Diagram"" from there.

You'll now be asked to add the tables you want to include in the schema. Add whichever tables necessary, and in case of relations defined in the table-schema, those will be added to the schema.

If you do not have the relationships in place, you can create them by dragging and dropping related columns manually from one table to the other.