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.
<< 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'