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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Table schema in XML format

Author  Topic 

kalyan.cse05
Yak Posting Veteran

74 Posts

Posted - 2014-04-04 : 07:19:01
I have a table.
Column A Column B Column C
1 2 3
4 5 6

I need the schema details of the table like datatype of column A , B and C as well as default values of all the columns and all other details of those 3 columns.

Can someone please help?


kalyan Ashis Dey

MuralikrishnaVeera
Posting Yak Master

129 Posts

Posted - 2014-04-04 : 07:43:44
Select table and press ALT+F1 you will get complete info about table and it's column

---------------
Murali Krishna

You live only once ..If you do it right once is enough.......
Go to Top of Page

kalyan.cse05
Yak Posting Veteran

74 Posts

Posted - 2014-04-04 : 08:15:58
I need that in XML format

kalyan Ashis Dey
Go to Top of Page
   

- Advertisement -