SHOW INDEXES FROM `providers`;
By the way, what version of MySQL are you using ???
----- Original Message -----
From: "Tim Johnson" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, February 21, 2007 3:35:46 AM (GMT-0500) Auto-Detected
Subject: Re: Retrieving foreign keys and references
On Wednesday 21 February 2007 17:01, Rolando Edwards wrote:
> SHOW CREATE TABLE providers\G
Hi Rolando:
That doesn't do it on my machine (linux, ver 4.0.2)
Here's what I see
mysql> SHOW CREATE TABLE providers\G
*************************** 1. row ***************************
Table: providers
Create Table: CREATE TABLE `providers` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '**',
`nick_name` varchar(10) NOT NULL default '**',
`email_address` varchar(80) NOT NULL default '**',
`start_date` date NOT NULL default '0000-00-00',
`company_ID` int(11) NOT NULL default '0',
`status` int(6) default NULL,
`modified` timestamp(10) NOT NULL,
UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM
1 row in set (0.00 sec)
As you can see there is no reference info for column `status`
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]
