Re: hot to obtain metadata on tables

[Stefan Hinz, iConnect \(Berlin\)]

Nedim,

> I am new to MySql. I need to obtain information about tables including
the
> names and types of each column, the primary keys etc.

SHOW TABLE STATUS;

To see only tables starting with "t": SHOW TABLE STATUS LIKE 't%';

http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "M.Nedim Alpdemir" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 19, 2003 6:32 PM
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  command does this. But are
there
> some system tables (similar to MS SQL server or IBM DB2) that I can
query
> for more detailed information?
>
> Can I obtain this kind of information by a single select statement
(using
> show tables and describe etc.).
>
> Any help will be appreciated?
>
> Thanks in advance?
>
> Nedim.
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

hot to obtain metadata on tables

[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  command does this. But are there
some system tables (similar to MS SQL server or IBM DB2) that I can query
for more detailed information?

Can I obtain this kind of information by a single select statement (using
show tables and describe etc.).

Any help will be appreciated?

Thanks in advance?

Nedim.




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php