This topic is locked

Duplicating Table setup

6/28/2006 11:14:51 AM
ASPRunnerPro General questions
M
mr_coder author

Hypothetical scneario.
15 Tables .... All identical fileds (Basically 15 copies of the original)
Now without going through ALL 15 ... and setting up field properties, filed types, etc
Is there way to apply the original table's settings to all other 15 ?

Sergey Kornilov admin 6/28/2006

Theretically you can create a setup for one of tables, open project file in text editor and copy&paste table definition seceral times replacing table name. Probably this will work.
As a side note - if you have several identical table it can be good idea to merge them into a single one adding a new field (CategoryID or something).

M
mr_coder author 6/29/2006

Thanks ! ... And yeah merging the table and tagging each record worked better.