Script entire database SQL-Server

Question

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.

Answer 1

Follow these steps:

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