?
Solved

table "desc" equivalent in Sql Server

Posted on 2011-03-14
4
Medium Priority
?
632 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 1000 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 1000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

840 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