How to - generate CREATE TABLE script based on existing table in Stored Procedure

Jose

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

How to - generate CREATE TABLE script based on existing table in Stored Procedure

Hi, how do you generate CREATE TABLE script based on an existing table in a
stored procedure. Something like, a stored procedure, where I pass the
Table name and Database name and this stored procedure will output the
CREATE TABLE script. How do I write this stored procedure or get this
accomplished?

Please advise.

Jose...

Other Threads

1. Creating Empty Table with Structure of existing table

2. Can i create table via existing table structure ?

3. How can create Table checking if Exists Table?

4. Creating a table by borrowing the structure of an existing table

5. CREATE TABLE vs CREATE TABLE + ALTER TABLE

6. How to determine that a table is existed in a data base in MSSQL

7. Multiple CREATE TABLE in one SQL script - how to run at once

8. Creating Tables froM Resource-based Definitons"

9. Deleting from table based on info in linked table

10. Database Desktop & Create Table based on SQL