Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

copy table sql server

-- Use SELECT ... INTO:
SELECT * INTO my_table_1 FROM my_table;
-- Structure only:
SELECT * INTO my_table_1 FROM my_table WHERE 1 <> 1;
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #copy #table #sql #server
ADD COMMENT
Topic
Name
3+1 =