How can I: Copy a table with Visual Studio 2008?

Question

Hello:

I have to create a bunch of tables with the same 10 fields at the top. I would like to create one table with the original 10 fields and then copy it to the other 60 table. Is there an easy way, or do I have to create each one manually by entering the 10 fields?

Amit Choudhary · Answer

hi Giorgio Generate SqlScript for creating table structure with your 10 fields. use the same sql code just change table name execute it as many times as you wants. mark as answer if get some hint.

Gustavo · Answer

OK I found what the issue was. It did not like AUTO_INCREMENT. I had to change it to: CREATE TABLE [Bin] ( [SEQNO] INT NOT NULL IDENTITY ( 1  1 ) PRIMARY KEY  [Status_ID] varchar ( 50 ) [Class_ID] varchar ( 50 ) [Group_ID] varchar ( 50 ) [Type_ID] varchar ( 50 ) [CreateBy] varchar ( 50 ) [CreateDate] varchar ( 50 ) [CreateTime] varchar ( 50 ) [Note] varchar ( MAX ) );

Gustavo · Answer

This is the script that I wrote but it does not like something on line: [SEQNO] int NOT NULL AUTO_INCREMENT  CREATE TABLE Bank ( [SEQNO] int NOT NULL AUTO_INCREMENT  [Status_ID] varchar ( 50 ) [Class_ID] varchar ( 50 ) [Group_ID] varchar ( 50 ) [Type_ID] varchar ( 50 ) [CreateBy] varchar ( 50 ) [CreateDate] varchar ( 50 ) [CreateTime] varchar ( 50 ) [Note] varchar ( MAX ) PRIMARY KEY ( SEQNO ) )

paul daniel · Answer

Refer this link http://www.java2s.com/Code/Oracle/Table/Createacopytableandinsertvaluetoit.htm

Gustavo · Answer

Amit: Thanks... I was hoping to do it with a tool (GUI). Im not that good at SQLScripts but it will save a lot of time. Thanks.

Gustavo · Answer

Amit: They are MS SQL tables.

Amit Choudhary · Answer

hi Giorgio What kind of tables these are??