From: Martijn Tonies
Date: November 26 2004 1:20pm
Subject: Re: How to retrieve constraints and links from MySQL tables?
List-Archive: http://lists.mysql.com/mysql/176426
Message-Id: <01fd01c4d3ba$a2eaef60$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



> So, I'm running a MySQL database (version: 4.0.21) for
> a personal project of mine, and I would like to learn
> how to retrieve constraints and links from the table
> after it's been created. The create statements read
> thusly:
> When I run "show columns from employees", there is no
> indication that the "position_id" field in "employees"
> is linked to that of "positions". This is the
> resulting table:

The only way to do this is via
SHOW CREATE TABLE <name>

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com