Friday, August 12, 2011

Backup Query


Backup Query
The Backup Query create a exact back up copy of table 'stu_table'. The create table construct a table'stu_table_backup' and copies the exact data of table 'stu_table'. The SELECT INTO statement is most often used to create backup copies of tables
create table stu_table_backup( select * from stu_table);

No comments:

Post a Comment