Script creation from existing table

[ramaswamynanda]

Hello All,

I have a table called employees in my mdb file. Is there any way to create a script for table creation from this existing table. Something like reverse engineering.
Is there an option where we can select a table and then say "generate script"

Thanks for your help
Nanda

[Jim Doherty]

Hello All,

I have a table called employees in my mdb file. Is there any way to create a script for table creation from this existing table. Something like reverse engineering.
Is there an option where we can select a table and then say "generate script"

Thanks for your help
Nanda

the simple way

SELECT * INTO YourtNewTableName
FROM YourExistingTableName
WHERE FALSE;

or if you like ....the impossible select statement

SELECT * INTO YourNewTableName
FROM YourExistingTableName
WHERE ((1=2));

Jim

[ADezii]

Hello All,

I have a table called employees in my mdb file. Is there any way to create a script for table creation from this existing table. Something like reverse engineering.
Is there an option where we can select a table and then say "generate script"

Thanks for your help
Nanda

I am a little confused on exactly what you are requesting. From a Table, in this case employees, do you want to generate the code to recreate this same Table exactly? If this is the question, the answer is yes it can be done, but it would be a complex undertaking recreating the Fields, Indexes, Relationships, Primary Key, Data Types and Sizes of the Fields, Validation Rules, Properties such as Required, Allow Nulls, etc., etc., etc.,....Just for curiosity, why would you want to do this?