Marcus Aurelius
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.