MSSQL Question

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
6/3/2011 8:33:30 AM
Jonathan Delfraisse
Gravatar
Total Posts 76
View Posts

MSSQL Question

This question is not directly related to mojoPortal, but I am hoping someone can help me.  I need to make a temp backup of a table with all of the keys, constraints, triggers, indexes, and data.  I found "SELECT * INTO tblNew FROM tblOld", but it does not copy keys, constraints, triggers, indexes.  My Google search continues, but I am not finding how to copy the things above as well as the data.

Thanks for your time.

6/3/2011 8:47:48 AM
Aaron W
Gravatar
Total Posts 115
View Posts
mojoPortal Community Expert

Re: MSSQL Question

The easiest way is to script the original table and use that script to create a new one with a different name then just use you SELECT INTO.

You must sign in to post in the forums. This thread is closed to new posts.