Link to home
Start Free TrialLog in
Avatar of Marcus Aurelius
Marcus AureliusFlag for United States of America

asked on

How to generate Create Table Script for multiple Tables in a Schema at one time?

Experts,

Is there a way for me to create CREATE TABLE Scripts for all of me existing tables within a single SCHEMA in my Database? Not one at a time, but I need a script that will generate CREATE TABLE SCRIPTS into a single SQL Script. I know that I can right-click and select Script Table as CREATE, but I want to be able to run a script that will list out all 20 tables in my SCHEMA all at once and all in one single deployment script.

I would like to be able to extract the DDL for multiple tables in a single schema so that I can communicate this create table information to my DBA so that they can create these tables in our PROD environment.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial