Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k points)

Is there a way I can get scripting of all tables, procs, and other objects from a database? I know there's an option to script the database but it only gave me some sort of top-level script, certainly not a script to create all tables, procs, udfs, .etc.

1 Answer

0 votes
by (40.4k points)

Follow these steps:

  • Go to Management Studio then Right-click on your databaseAfter that select Tasks and click on Generate Scripts.

Browse Categories