Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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.
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.5k questions

29.9k answers

500 comments

99.1k users

Browse Categories

...