Does sybase support SQL-92's Information_schema ??? Most of the other database servers do.
Last edited by loquin; 04-01-08 at 14:51.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
As far as I know Sybase is not fully sql 92 compliant.
Im guessing you are looking for something like this, and dont think this exists. Can you mention a little bit more of what you are trying to do, so that we can provide other means to do the same.
The SQL Standard INFORMATION_SCHEMA, also known as the metadata or the system tables, is where you get to look at the definition of your database. It's not just tables (there are domains in it too plus all the predefined character sets / collations / translations), but the interesting things are in these tables, all of which can be accessed using:
SELECT ... FROM INFORMATION_SCHEMA.table-name