c# - How to copy sql table with all structure( key constraints) and data to another table?

Question

is there any way to copy sql table with key constraints(complete structure) and data to another table through command without using sql studio UI.

Answer 1

Right click on the table --> choose "Script table as" --> "Create to" --> "New query editor window". You'll get the create statement. For transporting data then use the insert statement.

INSERT INTO table1 SELECT * FROM table2