Create a table with the same constraints,triggers,indexes, and statistics for house-keeping table
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