Clone the table with constraints?

Posted by Rajujrk under Sql Server on 2/26/2010 | Views : 1379 | Status : [Member] | Replies : 3
Hai,

Sorry already i post a question related with the current posting.. But i forgot to ask about it..

i want to clone the table with the constraints?

Thanks & Regards

Rajkumar J



Responses

Posted by: Abhi2434 on: 2/26/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
What you are looking for?
Is it you want to give constraint to the data to be selected... or the table level constraints ?

It could easily done to filter records using
Where clause in select statement.

But if you want all the keys, indexes to copy, it wont be easy.


www.abhisheksur.com

Rajujrk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sagarp on: 3/24/2010 [Member] Bronze

Up
0
Down
Read following article


http://www.protocolostomy.com/2008/10/09/clone-a-table-in-mysql-without-killing-your-server/


Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/

Rajujrk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 6/26/2012 [Member] Starter | Points: 25

Up
0
Down
what u r looking explain clearly

regards

sriram

Rajujrk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response