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 is varchar example?

1075

what does the t-sql command ident_current does? : Transact sql

1042

What is an oracle stored procedure?

1110

What is cartesian join in sql?

1186

What are the types of variables use in pl sql?

1082

Which kind of parameters cannot have a default value in pl sql?

1202

Difference between truncate, delete and drop commands?

1134

Can we use view in stored procedure?

951

What are sql triggers used for?

1030

What are the types of queries in sql?

1119

How can I speed up sql query?

1002

Explain the difference between rename and alias?

1061

what are the advantages of sql ? : Sql dba

1105

How do I count duplicates in sql?

1170

What are the indexing methods?

1095