Solved

table "desc" equivalent in Sql Server

Posted on 2011-03-14
4
597 Views
Last Modified: 2012-05-11
table "desc" equivalent in Sql Server..?
0
Comment
Question by:N_Sri
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 9

Accepted Solution

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

Expert Comment

by:Ephraim Wangoya
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
query optimization 6 22
sql 2016 data tools breakdown.. 1 28
SSIS Standard Template for Reuse by Business Units 12 50
Can a Trigger trigger a Trigger? 4 22
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 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