Solved

table "desc" equivalent in Sql Server

Posted on 2011-03-14
4
566 Views
Last Modified: 2012-05-11
table "desc" equivalent in Sql Server..?
0
Comment
Question by:N_Sri
4 Comments
 
LVL 9

Accepted Solution

by:
sshah254 earned 250 total points
ID: 35133341
0
 
LVL 32

Expert Comment

by:ewangoya
ID: 35134352

What do you mean by "desc"
If its ordering of data, then that is a standard in sql which all sql databases support

select * from Table1
order by field1 desc
0
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 250 total points
ID: 35134735
Oracle desc equivalent in SQL Server is sp_help and the syntax would look like

sp_help table_name
or
sp_help "schema_name.table_name"
0
 

Author Closing Comment

by:N_Sri
ID: 35287090
thankyou
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server 2008 R2 - Updating Table/Fields Documentation 3 67
replication - alerts? 4 30
select over clause 1 40
In or Between 2 44
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now