Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rupal kankaney
Starting Member
2 Posts |
 Posted - 2007-08-06 : 03:14:02
|
| Hi AllI want to convert table structure into xml in the following format.Eg: <TABLE_NAME> <COLUMN_NAME> <IS_NULLABLE> </IS_NULLABLE> <CONSTRAINT_TYPE> </CONSTRAINT_TYPE> <CONSTRAINT_NAME> </CONSTRAINT_NAME> <TABLE_CATALOG> </TABLE_CATALOG> <LENGTH> </LENGTH> </COLUMN_NAME></TABLE_NAME>where TABLE_NAME is the table name in database and COLUMN_NAME is name of the column in above table and the remaning are the attributes to that column.please suggesst me the sql query to get the following structre of any table in database,Thanks Rupal |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
Table structure into xml URGENT