Good morning All,

What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY, or
FOREIGN KEY of and schema?

Thanks.................Nguyen.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

--=_alternative 0045D49E85257054_=
Content-Type: text/plain; charset="US-ASCII"

"Nguyen, Phong" <Phong.Nguyen (AT) disa (DOT) mil> wrote on 08/05/2005 08:26:58 AM:

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
--=_alternative 0045D49E85257054_=--

Hello.


I think you should use the SHOW statements:
http://dev.mysql.com/doc/mysql/en/sh...ate-table.html
http://dev.mysql.com/doc/mysql/en/show-index.html



"Nguyen, Phong" <Phong.Nguyen (AT) disa (DOT) mil> wrote:

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko (AT) ensita (DOT) net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw