• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

Table Schemas in XML

How can I get the schemas for a group of tables in XML format?
0
PsychoDazey
Asked:
PsychoDazey
  • 2
1 Solution
 
anthonywjones66Commented:
Use .NETs 'Infer schema' technique?
0
 
PsychoDazeyAuthor Commented:
How do I do that?
0
 
obahatCommented:
Why not simply:

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

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now