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

How do I run a sql query?

1017

What are sql functions? Describe in brief different types of sql functions?

1103

Which command is used to delete a trigger?

1332

what is the difference between char_length and length? : Sql dba

1044

What does over partition by mean in sql?

978

What are sql constraints?

1174

What is implicit cursor in pl sql?

1091

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1003

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2222

How do I run sql profiler?

1068

What is the advantage of index in sql?

971

How to write html code in pl sql?

1116

what are the performance and scalability characteristics of mysql? : Sql dba

996

How many types of literals are available in pl sql?

1119

Does view store data in sql?

964