Since information_schema is a standard, where can i find the documentation of it?

Question

Hi,

Many databases has a information_schema database, since it is a standard. I want to know where can i find the documentation of it. Such as meaning of columns etc.

Thanks.

Answer 1

Is this what you're looking for? Information Schema Views Click on the various links to see the column details for each view. For example: Information_Schema.Tables

Answer 2

Try a google search for "information_schema" and then click a few links...

Answer 3

There's various version of the SQL standards. They are not freely available though. Wikipedia links to the relevant ISO/IEC pages, e.g. here http://en.wikipedia.org/wiki/SQL:2006 and http://en.wikipedia.org/wiki/SQL:1999

Here's a copy of the older SQL-92: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

For user documentation, you're probably better off looking in the relevant documentaion for your database, such as the information schema docs for PostgreSQL or SQL Server