Duplicate Table Definition (columns) in SQL-Server -


Is there a quick and easy way to duplicate a table in SQL-Server? I just want to create a temporary table from Table A because I have to refresh Table B (which will interfere with the foreign key).

I know that it is not a ridiculous task to do it manually, but it seems that it should be a good way to do this.

EDIT: To clarify, I want to duplicate table definition , not actual data

when you're refreshing Will not it be a better way to temporarily disable obstacles? / P> 

  Alternate table X Knokkas contract all - Refresh SQL alter tab X check contract all

Comments

Post a Comment