> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
