DESC in SQLServer

[skp12]

Can any one help me in sending the' desc 'command in SQL Server.


Thanks in advance

 

[ca8msm]

Umm send it to where?

order by myfield desc

Is that what you mean?



-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[skp12]

I need description (data type ) of whole table.


Example in ORACLE

DESC <tablename>
I need the same in SQL Server

 

[ca8msm]

Look up the Information Schema views in your help files.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[ptheriault]

To get the table description plus a whole lot more. use sp_help table name

- Paul
- If at first you don't succeed, find out if the loser gets anything.