From: "Jonathan Stowe" <[EMAIL PROTECTED]> > On Fri, 6 Jul 2001, Aaron Trevena wrote: > > > On Fri, 6 Jul 2001, Jonathan Stowe wrote: > > > > > > > Maybe I'm just blind and stupid but I cant find any description of the > > > schema in the database itself - I would be delighted to find that I could > > > do the equivalent of a 'select * from systables'. > > > > in the mysql database in mysql > > > mysql> show taBLES; > +-----------------+ > | Tables in mysql | > +-----------------+ > | columns_priv | > | db | > | func | > | host | > | tables_priv | > | user | > +-----------------+ > 6 rows in set (0.37 sec) > > Er ... > > > you have such things as the tables table, etc. > > Also "showtables;" at the mysql prompt and "desc tablename;" > > is that what you are after? > > No what ER Codd is after is that the schema is part of the database - I > dont think this is true of MySQL. If it walks like a duck, and it sounds like a duck.... /Robert