Hi

i have 300 tables , i must examine all ONLY for read the description in the
Header , in fast mode.

( i don't read any internal data / fields.... )


i must .open the table ?

Enrico


Its more a case of you can't read the header by opening the table

With ElevateDB all the table metadata is stored in the catalog and to examine any of it you read the system tables.

So you'd need to do something like

select Name, Description from information.tables

Roy Lambert [Team Elevate]

Enrico,

<< i have 300 tables , i must examine all ONLY for read the description in
the Header , in fast mode.

( i don't read any internal data / fields.... )

i must .open the table ? >>

Nope. As Roy indicated, just run this query against the current database:

SELECT Name, Description
FROM Information.Tables

--
Tim Young
Elevate Software
www.elevatesoft.com