Developer Docs

Export Schema using SQL Server Management Studio (SSMS)

SQL Server Management Studio(SSMS) is an integrated environment for managing any SQL Server databases. SSMS provides tools to configure, monitor, and administer database instances of SQL Server.

Please follow the steps below in order to export your schema structure using SSMS:

  1. At the left pane, right click the database you would like to export the schema structure for.

  2. Choose Tasks => choose Generate Scripts Image
  3. Click next at the welcome screen.

  4. Click next at the “Select the database objects to script” screen. Image
  5. Click advanced => select the option “Types of data to script” and choose “schema only”.

  6. Choose the path to export the file to, and click next. Image
  7. Click Finish.

Was this article helpful?

Thanks for your feedback!

If you would like to tell us more, please click on the link below to send us a message with more details.







On this page

New to Codebots?

We know our software can be complicated, so we are always happy to have a chat if you have any questions.