Looking For A Command To Show Table Structures On The Screen

Looking For A Command To Show Table Structures On The Screen

Post by Leon Pappadopoulo » Tue, 05 Feb 2002 19:01:20



dbschema -d <database> -t students

-----Original Message-----

Sent: Saturday, February 02, 2002 6:19 PM

Subject: 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

 
 
 

Looking For A Command To Show Table Structures On The Screen

Post by aleato » Thu, 07 Feb 2002 22:50:14


Hi all!

Thanks mcuh! Volker, Paul, rkusenet, Leon and others by
e-mail gave me lots of helpful tips. The tips you guys
gave me will tremendously save me time at work.

Thanks! :)

alea


> dbschema -d <database> -t students

> -----Original Message-----

> Sent: Saturday, February 02, 2002 6:19 PM

> Subject: 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


 
 
 

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. Database Administrator

3. SQL command (like DESCRIBE) to show structures?

4. SWITCHCurrentDatabase

5. Unreal table size showing in Manage Index screen

6. Set DataRepeater.RecordSource at runtime?

7. get table structure via sql commands

8. VB 6.0 & SQl server 6.5

9. What command is for displaying table structure?

10. modify table structure with commands?

11. multiple screen, multiple table screen sets

12. XP Logon screen shows unread email...when no email exists