Ever wanted to replicate a table and its contents in MS SQL?
heres how:
SELECT * INTO NewTable FROM OldTable
Want to copy just the structure and not the content?
SELECT TOP 0 * INTO NewTable from OldTable
Ever wanted to replicate a table and its contents in MS SQL?
heres how:
SELECT * INTO NewTable FROM OldTable
Want to copy just the structure and not the content?
SELECT TOP 0 * INTO NewTable from OldTable
Thanks alot. It worked for me
It doesnt work at my end 🙁
It says : Sysntax error : INTO clause is not allowed
what to do?
@sundhas, can you please show us what sort of query you ran?
🙂 It works! Thank you. I love this kind of tip.