Script to copy SQL server table structures (filter + add columns)

Question

is there a way I can write a script to find all tables with a given filter (e.g. all tables that start with "tbl_") and copy them (structure only) but adding a new standard column to each one?

I'm using SQL server 2008.

Thanks in advance.

Cade Roux · Accepted Answer · 2010-07-15 17:02:23Z

1

Yes

Use the Metadata: INFORMATION_SCHEMA.TABLES, INFORMATION_SCHEMA.COLUMNS

Generate table creation scripts in a different schema or database or table name with the additional columns

answered Jul 15, 2010 at 17:02

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mikalee Over a year ago

Thank you - that was enough to help me find a more detailed answer here: social.msdn.microsoft.com/Forums/en/transactsql/thread/…

Collectives™ on Stack Overflow

Script to copy SQL server table structures (filter + add columns)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related