Table Schemas in XML

How can I get the schemas for a group of tables in XML format?
LVL 6
PsychoDazeyAsked:
Who is Participating?
 
obahatCommented:
Why not simply:

SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME ('<TableName1>', '<TableName2>', ...)
FROM XML AUTO

0
 
anthonywjones66Commented:
Use .NETs 'Infer schema' technique?
0
 
PsychoDazeyAuthor Commented:
How do I do that?
0
 
PsychoDazeyAuthor Commented:
Im getting:
Incorrect syntax near the keyword 'FROM' oh never, you have from xml, it should be for.

Looks good, Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.