Modifying table structure programmatically

[Alexei Adadurov]

Hello all!
I'm new to ADO.NET and I have 2 questions:

1. I need to programmatically create a copy of a table (say, 'table1'),
named something like 'table1_copy', containing only the structure of the
source table and no data.
I tried to use System.Data.DataTable.Clone() to create a copy of a
table, but couldn't get it saved into the DB. Is there any way to do that?

2. I need to modify the structure of a table (e.g. create couple of new
fields). I can add objects to the Columns collection of
System.Data.DataTable object, but, again, cannot save changes into the
database.
What's the correct way to do that?

Thanks in advance,
Alexei N. Adadurov.
alexei.adadurov[at]mail.ru

Have anybody tried to create a copy of a table in a Microsoft Access
database

 

[Patrice]

It's likely easier to just send the SQL statement command :

SELECT * INTO DestTable FROM SourceTable WHERE 1=0 should duplicate
SourceTable into DestTable (structure only)
http://office.microsoft.com/en-us/assistance/HP010322661033.aspx

ALTER TABLE MyTable ADD COLUMN MyColumn TEXT(40) NOT NULL allows to add a
new field.
http://office.microsoft.com/en-us/assistance/HP010322071033.aspx


Patrice

 

[Alexei Adadurov]

Thanks alot, Patrice!

Alexei N. Adadurov.
alexei.adadurov[at]mail.ru