Hi:
Below is the following relevant create table syntax
CREATE Table providers(
[snipped]
FOREIGN KEY (status) REFERENCES provider_status(ID,title),
UNIQUE KEY ID (ID)
) TYPE=MyISAM;
and below is the relevant output from a describe query:
mysql> show columns from providers;
+---------------+---------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra
+---------------+---------------+------+-----+------------+----------------+
| status | int(6) | YES | | NULL |
+---------------+---------------+------+-----+------------+----------------+
Is there a syntax equivalent of 'describe' that can show me the references?
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
Palmer, Alaska, USA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
