table data copying in sql

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 .

0

suresh kumar10y ago

while copying data from one table into other table,in the first table we are mentioning constraints on coloumns,after 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

0

Akshay Phadke10y ago

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

0