In relational databases, the information schema is an ANSI standard set of read-only views which provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information which some databases make available through non-standard commands, such as the SHOW command of MySQL and the DESCRIBE command of Oracle. => select count(table_name) from information_schema.

PropertyValue
dbpprop:abstract
  • In relational databases, the information schema is an ANSI standard set of read-only views which provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information which some databases make available through non-standard commands, such as the SHOW command of MySQL and the DESCRIBE command of Oracle. => select count(table_name) from information_schema. tables; count (1 row) => select column_name, data_type, column_default, is_nullable from information_schema. columns where table_name='alpha'; column_name | data_type | column_default | is_nullable ------+----+--+------ foo | integer | | YES bar | character | | YES (2 rows) => select * from information_schema. information_schema_catalog_name; catalog_name johnd (1 row)
dbpprop:reference
rdfs:comment
  • In relational databases, the information schema is an ANSI standard set of read-only views which provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information which some databases make available through non-standard commands, such as the SHOW command of MySQL and the DESCRIBE command of Oracle. => select count(table_name) from information_schema.
rdfs:label
  • Information schema
skos:subject
foaf:page
is dbpprop:redirect of