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

Gustavo

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?

7 Replies

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

Amit Choudhary16y ago
Accepted 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.
Gustavo16y ago
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)
);
Gustavo16y ago
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 daniel16y ago
Refer this link

http://www.java2s.com/Code/Oracle/Table/Createacopytableandinsertvaluetoit.htm
Gustavo16y ago
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.
Gustavo16y ago
Amit:

They are MS SQL tables.
Amit Choudhary16y ago
hi Giorgio,
What kind of tables these are??