User Id :    Password :      New Member   Forgot Password  
Topic: Write a query when we need a copy structure of one table to another table
Anamika singh
11 Oct 2010 at 03:17 AM
Write a query when we need a copy structure of one table to another table or you can say example of cloneing?
Re: Write a query when we need a copy structure of one table to another table
Gaurav
12 Oct 2010 at 03:15 AM

Copy table structure only

WE can copy only structure and create a new table like this.
Here we will create a new table t1 by using structure of student table. ( No data is copied)

create table t1 like student

Total Replies: 1
 
Featured Text Ad

Featured Ad