0 votes
1 view
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 (36.7k points)

Follow these steps:

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