SELECT column_name(s) INTO new_table_name FROM old

write the Sql query for creating database backup?

Question Posted / vikneswaran

Answer Posted / vikneswaran

SELECT column_name(s)
INTO new_table_name
FROM old_tablename

Is This Answer Correct ?

3 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What are the key differences between SQL and PL SQL?

1222

How many types of keys are there in sql?

1044

what is the syntax used for partition in tsql? : Transact sql

1024

Is a table valued function object?

1027

What is procedure and function?

998

What is sql used for?

1129

Can you upgrade sql express to full sql?

1077

What is denormalization in a database?

1060

what is heap table? : Sql dba

1113

What is on delete set null?

1096

What is right join sql?

969

define sql insert statement ? : Sql dba

1034

How would you pass hints to the sql processor?

991

What does trigger mean in psychology?

971

describe transaction-safe table types in mysql : sql dba

1011