MySQL Forums
Forum List  »  Spanish

Re: metadata - información de las tablas
Posted by: William Chiquito
Date: October 31, 2006 06:13PM

Hola Carlos,

Esto te puede servir:

select c.table_name, c.column_name, c.data_type
from information_schema.tables t
left join information_schema.columns c on t.table_schema = c.table_schema and t.table_name = c.table_name
where t.table_schema = '[tu base de datos]';

Options: ReplyQuote

Written By
Re: metadata - información de las tablas
October 31, 2006 06:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.