Solved

table "desc" equivalent in Sql Server

Posted on 2011-03-14
4
589 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query Syntax 17 42
Text file into sql server 5 32
Script to backup a Database Dayli on SQL Server Express 3 19
What is this datetime? 1 18
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…
In this article I will describe the Copy Database Wizard 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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 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