How to export SQL database schema

By Leo Snyder,2014-06-25 00:56
10 views 0
database schema schemaexport sql schema database.sqlquery sqldatabase web sql database sql database stisqldatabase sql export schema

How to export SQL database schema

    1. Use SQL Server Enterprise Manager

    2. right-click on database / all tasks / Generate SQL Script

    3. On General tab, click “Show All”

4. On Formatting tab, ensure that “Generate the CREATE….” and “Generate the

DROP….” are selected

5. On the Options tab, select “Script PRIMARY keys….”

6. Click OK and save file.

Report this document

For any questions or suggestions please email