I want each row in a new table I'm developing to contain the Data Definition Language (DDL) of one of my existing SQL Server 2000 tables. Which system files do I need to manipulate to capture the DDL? I could use script generation to create this table manually, but I need a more automated process. I prefer to develop the table in T-SQL and not venture into SQL-DMO programming. Can you help?
...