Create a table with the same constraints,triggers,indexes, and statistics for house-keeping table I have a current database with few hundred tables, say, tables A,B,C... and I want to create the same tables with the same constraints,triggers,indexes, and stats as the original tables.

I know I could use generate script to do this but is there a faster way?

Do I have to rename the "new" tables with different names as well as their constraints,indexes etc?
Right mouse click on your database -&gt; Tasks -&gt; Generate scripts -&gt; Tables:

On the next page select if you want to generate a single file or single file per object and go to Advanced:

Here select constraints, triggers, indexes and what else you want to script