Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

need sqlserver query to give similar output like dec command in sqlserver Expand / Collapse
Author
Message
Posted Thursday, July 18, 2013 1:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 22, 2013 1:52 AM
Points: 3, Visits: 5
Hi,

I need sqlserver query to give output like DESC TABLE_NAME command in oracle.

I know sp_help 'table_name.but i want output like below,

COLUMN_NAME NULL TYPE
ID YES NUMERIC(38)
DATEFILED NO DATE
NAME VARCHAR(250)
DECIMAL DECIMAL(22,2)


It is similar to desc command in oracle.The same way and format,i need sql.

Please help me on this.
Post #1474922
Posted Thursday, July 18, 2013 1:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 6,719, Visits: 13,828
Split from this thread.

“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1474925
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse