Copy a SQL 2000 Db using CF MX

[zeejayy]

I'm looking for a good method to copy a database and generate the SQL create table scripts programmaticly using Coldfusion MX 7 and SQL Server 2000.

The idea is to have CF template that can read out all tables and columns from a development DB, and then generate the SQL query's to recreate the structure to a new db, sans data, on the fly.

I've gone looking around in the schema and i can't seem to find all the information i need to write my own script for the operation. Particularly i can't seem to find attributes for auto increment fields that are being used for Primary keys in many of the tables.

Any info on this sort of method is appreciated.

[Dan_Bracuk]

google "ms sql system tables"

[zeejayy]

Very good search string, thanks!