• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

creating backup tables

 
vidhya Narayanan
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"create table table_backup as select * from table"
this creates the new table with the same structure but not with the key constraints..
How to get the keys and constraints in the same sql stmt.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic