get sql server schema to xml?

[suzy]

Hello,

How can I get table/column schema of a sql server database? i want to
convert the entire schema into an xml file.

thanks in advance.

 

[William Ryan]

You can use a DataReader's GetSchemaTable method

 

[William Ryan]

Oops, sorry for not posting the link... you can do it with the Connection
Object as well... here's a pretty good discussion of it..
http://msdn.microsoft.com/library/d...conobtainingschemainformationfromdatabase.asp

 

[suzy]

great thanks.... i will give that a try

Oops, sorry for not posting the link... you can do it with the Connection
Object as well... here's a pretty good discussion of it..
http://msdn.microsoft.com/library/d...conobtainingschemainformationfromdatabase.asp

 

[suzy]

The example only lists tables. Any idea on how to get additional
information in one query? (ie: field/column information)?

 

[William Ryan]

If you use the DataReader for example, it gives you all three.