in the dataset designer surface I tried to copy a table and past, rename . the copied table seems to be some sort of view of of the original.
when I executed some delete query on the orginal table, I found in preview of the 'cloned" table also loses those rows.
So what is the way to clone a table independent of the original?
does not look like I can copy not even using sql query
select * from tabl1 into tabl2
regardless if tabl2 exists or not
the ony way to create more table is use the sql managment tool to connect the the sdf and make new table
even with mssms, one can' execute the sql select * from tabl1 into tabl2
I guess one could copy row by row using .net app from a table to another
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?