How to convert SQL Table Schema into XML format

• Deepak Gupta-344956

  Grasshopper

  Points: 23

  More actions

  August 7, 2006 at 2:53 am

  #76561

  Hi,

  I need to convert the SQL Server Table structure (Schema) into the XML format. I am able to convert the SQL data to XML but I need to convert the Table structure. Can anyone help me to do that. I'll be really grateful to him/her.

  Thanks.

  Deepak.

   

• Bhushan

  Default port

  Points: 1427

  More actions

  August 7, 2006 at 4:23 pm

  #653750

  use information_schema.columns view. Rest is same as you did for SQL Data