I need to copy a table I already I have in a SQL server database, but I don't need the data contained in the source table. The examples I found only involve copying the data.
Here are the details:
select * into new_table from old_table where 1=0
Execute the above command programmatically.
Script out the table, change the table name in the script, run the script.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With