Copy table with same structure with different name in same database

Question

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

Kirtan Patel · Answer

Make Script of Table By following and use it in programming :)

Vikram · Answer

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

Rajeswari nathan · Answer

hellow please try the following kind of query SELECT * INTO ForumUsers1 FROM ForumUsers WHERE 1=2 SELECT * INTO MyUsers1 FROM MyUsers WHERE 1=2

Vikram · Answer

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

Rajeswari nathan · Answer

Did you check the options tab (Table scripting option) for script primary key ... when creating the script..

Vikram · Answer

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

Rajeswari nathan · Answer

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..

Kirtan Patel · Answer

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;