hot to obtain metadata on tables

2003-01-19 Thread M.Nedim Alpdemir
Hi all, I am new to MySql. I need to obtain information about tables including the names and types of each column, the primary keys etc. I understand that the describe table_name command does this. But are there some system tables (similar to MS SQL server or IBM DB2) that I can query for more

Re: hot to obtain metadata on tables

2003-01-19 Thread Stefan Hinz, iConnect \(Berlin\)
Subject: hot to obtain metadata on tables Hi all, I am new to MySql. I need to obtain information about tables including the names and types of each column, the primary keys etc. I understand that the describe table_name command does this. But are there some system tables (similar to MS SQL