SHOW CREATE TABLE providers\G
----- Original Message -----
From: "Tim Johnson" <[EMAIL PROTECTED]>
To: "MySQL General Mailing List" <mysql@lists.mysql.com>
Sent: Wednesday, February 21, 2007 2:59:35 AM (GMT-0500) Auto-Detected
Subject: Retrieving foreign keys and references
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
