Copy table with same structure with different name in same database

Vikram

Hi, I want to copy table with same structure with different name in same database by using c#.net. I tried it by using microsoft SQL Server Management Object (SMO) but get error against column's parent property. Is there any way to achieve this. Thanks

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Make Script of Table By following

and use it in programming :)
0
Vikram17y ago
Hi, Actually I already tried that option but it copied only field related information, primary key and foreign key related information was not copied. Thanks
0
Rajeswari nathan17y ago
hellow please try the following kind of query
SELECT * INTO ForumUsers1 FROM ForumUsers WHERE 1=2
SELECT * INTO MyUsers1 FROM MyUsers WHERE 1=2
0
Vikram17y ago
Hi Raji, Actually I want to copy around 180 table at a time with different names in same database as one activity. So that i can not use script for that. Thanks
0
Rajeswari nathan17y ago
Did you check the options tab (Table scripting option) for script primary key ... when creating the script..
0
Vikram17y ago
Hi, Thanks for your reply. I tried that option already. It copied only fields information, all other primary key and foreign key information are not copied. Is there any ways to copy all other information? Thanks
0
Rajeswari nathan17y ago
just create the script for that table ...
open the script in the SQL query ananyzer and change the table name only..
you will get new table with old structor. I think you catch my point..
0
Kirtan Patel17y ago
Hi Friend,

Here is What you want

dont forget to mark "Do you like this Answer" please if answer helped you :)

you can Copy Table Structure only By following Query to Server ..

select * into newTable from source where 1=2;
0