copying data fromone table to oher table

Question

copying data from one table to other table along with constarints like primary keycheckdefaultforeign key is possible? plz explain the answer

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 .