SQL command (like DESCRIBE) to show structures?

SQL command (like DESCRIBE) to show structures?

Post by Jeff Wel » Fri, 31 Mar 2000 04:00:00



can anyone tell me how to display a table structure using a query (i.e.
not the MMC GUI) from inside SQL server?  Other databases use commands
like \d table or describe table.  Is there an equivalent in SQL server?
 
 
 

SQL command (like DESCRIBE) to show structures?

Post by Ronnie Che » Fri, 31 Mar 2000 04:00:00


Try
sp_help [tablename]


Quote:> can anyone tell me how to display a table structure using a query (i.e.
> not the MMC GUI) from inside SQL server?  Other databases use commands
> like \d table or describe table.  Is there an equivalent in SQL server?


 
 
 

1. Looking For A Command To Show Table Structures On The Screen

Hi all,

A newbie question.

The Oracle SQL*Plus program has a very handy command called
"DESC" to show table structures on the screen. The following
shows its usage:

     | DESC students                        
     |
     | Name               Null?    Type
     | ------------------ -------- ----------
     | STUDENT_ID         NOT NULL NUMBER(8)
     | SALUTATION                  VARCHAR2(5)
     | FIRST_NAME                  VARCHAR2(25)
     | LAST_NAME          NOT NULL VARCHAR2(25)
     | STREET_ADDRESS              VARCHAR2(50)
     | ZIP                NOT NULL VARCHAR2(5)
     | PHONE                       VARCHAR2(15)
     | etc...

I'm looking for an equivalent Infomix command which does
the same thing. Is there any?

I appreciate any help.

Thanks in advance!

alea

2. Back from the crypt....

3. Cloning recordsets stored in Shared Property Manager

4. Limiting returns and describing table structures.

5. SystemError 705.0.53

6. SHOW and DESCRIBE

7. Help ms-sql connection problem

8. How to create Recordset describing a directory structure

9. Using Sqlda/Sqlca Structures with Describe

10. Summary re self-describing data structures

11. Self-describing host-independent data structures

12. Equivalent of SQL+ command DESCRIBE