"Nguyen, Phong" <[EMAIL PROTECTED]> wrote on 08/05/2005 08:26:58 AM:
> Good morning All, > > What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY, or > FOREIGN KEY of and schema? > > Thanks.................Nguyen. > I believe you are looking for the SHOW CREATE TABLE command. If I am using the MySQL CLI, I prefer the output formatted with the \G terminator instead of the ; terminator like this SHOW CREATE TABLE tablename\G Shawn Green Database Administrator Unimin Corporation - Spruce Pine