Firsty I am using SQl Server Compact in Webmatrix...I hope that helps...:)
yousaid
the easiest way to do this in less than five minutes is use the GUI and generate the script for the Table you already have.
STEP 2 will be to simply copy the genarated script and rename the tables and then CREATE the new ones.
Secondly could you please explain how to generate the script for the Table and then use it to create new ones.
Any sort of code would be highly appreciated...
rohilsethi
Member
9 Points
6 Posts
Re: Copying Table Definition to a NEW TABLE in Databases (Using WEBMATRIX)
Feb 25, 2012 09:52 AM|LINK
@yousaid : Thanks a lot for the reply :)
Firsty I am using SQl Server Compact in Webmatrix...I hope that helps...:)
Secondly could you please explain how to generate the script for the Table and then use it to create new ones.
Any sort of code would be highly appreciated...
Thanks :)