Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread SHOW TABLES, SHOW FULL COLUMNS FROM...
Fri, Jun 9 2006 5:37 AMPermanent Link

SteveW
Equivalent commands to MySQLs
SHOW TABLES;
and
SHOW FULL COLUMNS FROM TableName;
which makes it nice and easy to get schema information using the ODBC driver.
Fri, Jun 9 2006 9:51 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Steve,

<< Equivalent commands to MySQLs
SHOW TABLES;
and
SHOW FULL COLUMNS FROM TableName;
which makes it nice and easy to get schema information using the ODBC
driver.  >>

Our next version (ElevateDB) will have full catalog support, so you can just
do this:

SELECT *
FROM System.Tables
WHERE DatabaseName='Test'

or

SELECT *
FROM System.Columns
WHERE DatabaseName='Test' and TableName='TestTable'

--
Tim Young
Elevate Software
www.elevatesoft.com

Image