Table constraints and column names - C#

[Guest]

Hi
Is there any way to take out all the information from a table(field names,primary key info etc) and use that to create a totally new table

Would be great if you could suggest the classes required
Would be grateful if some of you guys can post some code samples in C#

Thank Yo
Julian

 

[Miha Markic [MVP C#]]

Hi Julian,

DataTable.Clone if you are reffering to ado.net DataTable.
Otherwise you should use either database specific commands or/and
GetOleDbScemaTable method (just for reading metadata).

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

Hi,
Is there any way to take out all the information from a table(field

names,primary key info etc) and use that to create a totally new table ?