On Fri, 2004-04-30 at 06:03, Richard A. DeVenezia wrote: > I'm running 4.1.1a-alpha-max-nt using innodb tables with foreign keys . > I know how to use SHOW TABLE STATUS to see the referential linkages in the > COMMENT column. > > Supppose I am typing away in MySQL monitor: > Q: Is there a way to create a table from the SHOW TABLE STATUS command ?
Not from SHOW TABLE STATUS, but you can duplicate a table. From the "create table" docs (http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html): "In MySQL 4.1, you can also use LIKE to create a table based on the definition of another table, including any column attributes and indexes the original table has: CREATE TABLE new_tbl LIKE orig_tbl; CREATE TABLE ... LIKE does not copy any DATA DIRECTORY or INDEX DIRECTORY table options that were specified for the original table." > Q: Does v5 have system views that are equivalent to SHOW xyz commands ? > > Thanks, > Richard A. DeVenezia > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]