bonjour,

Le jeudi 19 janvier 2006, Stephane Davy a écrit...


> Actually, I've seen these system views, but I had in mind that maybe a
> simple command was provided for that. So, I need to write a procedure
> for that ;-)

\dc tablename within sqlcli ?

Here is an output :


Table "JM.ANIMAL"
| Column Name | Type          | Length | Nullable | KEYPOS |
| ----------- | ------------- | ------ | -------- | ------ |
| IDANIMAL    | SMALLINT      | 5      | NO       | 1      |
| BOUCLE      | VARCHAR ASCII | 5      | YES      |        |
| TATOUAGE    | VARCHAR ASCII | 5      | NO       |        |
| NAISSEUR    | VARCHAR ASCII | 8      | YES      |        |
| SEXE        | CHAR ASCII    | 1      | YES      |        |
| TIPTAG      | VARCHAR ASCII | 5      | YES      |        |
| CORNES      | VARCHAR ASCII | 3      | YES      |        |
| CARACTERE   | VARCHAR ASCII | 40     | NO       |        |

-- 
jm



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to