table structure of the new table(Urgent)
-
hi all, I am copying a table to another table using select * into targettable from sourcetable . The new table named "targettable" is created but the primary key (constraints) and default values for the table are not coming as "sourcetable". Is there any way to have a table copy with the same table structure and design??????. vivek
-
hi all, I am copying a table to another table using select * into targettable from sourcetable . The new table named "targettable" is created but the primary key (constraints) and default values for the table are not coming as "sourcetable". Is there any way to have a table copy with the same table structure and design??????. vivek
vivek-g wrote:
Urgent
Sorry, but not to us it isn't.
-
hi all, I am copying a table to another table using select * into targettable from sourcetable . The new table named "targettable" is created but the primary key (constraints) and default values for the table are not coming as "sourcetable". Is there any way to have a table copy with the same table structure and design??????. vivek
Currently there is no such method to copy the constraints from the source to target table during table creation. For applying the constraints you must Alter the table. _____________________________ Success is not something to wait for, its something to work for.