|
|
|
If you want to copy the table from another table in same SQL server you can do it by using SQL SELECT statement to copy the table.
Here is the Syntax:
SELECT * INTO (destination_table) FROM (source_table)
EXAMPLE:
SELECT * INTO hr_table FROM management_table;
SELECT INTO is totally different from INSERT INTO STATEMENT.