table data copying in sql

Question

data present in one table is copied into other table in sql along with constraints like primary keycheckdefaultforeign key also present in copied table ?

Akshay Phadke · Answer

You can use import export wizard to copy data from one table to another just in deatination create a table which is same that of source table just generate a script it will create a table name that table something else which shouldnt match of source and use import export wizaed .

suresh kumar · Answer

while copying data from one table into other tablein the first table we are mentioning constraints on coloumnsafter copying into other table the data is coming but the constraints are not coming on coloumns? what i have do the constarints also come into the copied table

Akshay Phadke · Answer

O so what exactly you want ? what is your issue ?