About: Information schema

Facets (new session)
Description
Metadata
Settings
- Rule:
- Inverse Functional Properties:
- "Same As":

About: Information schema Goto Sponge NotDistinct Permalink

An Entity of Type : yago:SystemOfMeasurement113577171, within Data Space : dbpedia.demo.openlinksw.com associated with source document(s)
QRcode icon

http://dbpedia.demo.openlinksw.com/describe/?url=http%3A%2F%2Fdbpedia.org%2Fresource%2FInformation_schema&invfp=IFP_OFF&sas=SAME_AS_OFF

In relational databases, the information schema (information_schema) is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information that some databases make available through non-standard commands, such as:

Attributes	Values
rdf:type	yago:WikicatComputerStandards yago:Abstraction100002137 yago:Measure100033615 yago:Standard107260623 yago:SystemOfMeasurement113577171
rdfs:label	Information schema (en)
rdfs:comment	In relational databases, the information schema (information_schema) is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information that some databases make available through non-standard commands, such as: (en)
dcterms:subject	Databases American National Standards Institute standards Computer standards
Wikipage page ID	9780776 (xsd:integer)
Wikipage revision ID	1121271738 (xsd:integer)
Link from a Wikipage to another Wikipage	Presto (SQL query engine) Vertica View (database) Snowflake Databases SAP HANA SQL*Plus SQL Anywhere SQLite MonetDB MySQL Oracle metadata Apache Derby Apache Hive Apache Ignite SingleStore Column (database) Table (database) ANSI Adaptive Server Enterprise Firebird (database server) Relational database Stored procedure H2 (DBMS) HSQLDB Teradata American National Standards Institute standards Computer standards Trino (SQL query engine) MariaDB PostgreSQL IBM Db2 IBM Informix Ingres (database) Microsoft Access Microsoft SQL Server Mimer SQL Oracle Database Oracle database
Link from a Wikipage to an external page	http://h2database.com/html/grammar.html%23information_schema https://www.sqlite.org/pragma.html%23pragfunc https://mariadb.com/kb/en/mariadb/information-schema/ http://www.postgresql.org/docs/current/interactive/information-schema.html http://dev.mysql.com/doc/refman/8.0/en/information-schema.html http://msdn.microsoft.com/en-us/library/ms174156 http://msdn.microsoft.com/en-us/library/ms186778.aspx http://sourceforge.net/projects/ora-info-schema/
sameAs	Information schema Information schema Information schema Information schema
dbp:wikiPageUsesTemplate	dbt:As_of dbt:Mono dbt:Reflist dbt:Database-stub
has abstract	In relational databases, the information schema (information_schema) is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information that some databases make available through non-standard commands, such as: * the SHOW command of MySQL * the DESCRIBE command of Oracle's SQLPlus the \d command in psql (PostgreSQL's default command-line program). => SELECT count(table_name) FROM information_schema.tables; count ------- 99 (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) (en)
gold:hypernym	Set
prov:wasDerivedFrom	wikipedia-en:Information_schema?oldid=1121271738&ns=0
page length (characters) of wiki page	4498 (xsd:nonNegativeInteger)
foaf:isPrimaryTopicOf	wikipedia-en:Information_schema
is Link from a Wikipage to another Wikipage of	MySQL Oracle metadata Database catalog Metadata Information Schema SQL/Schemata
is Wikipage redirect of	Information Schema
is foaf:primaryTopic of	wikipedia-en:Information_schema

Faceted Search & Find service v1.17_git139 as of Feb 29 2024

Alternative Linked Data Documents: ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 08.03.3330 as of Mar 19 2024, on Linux (x86_64-generic-linux-glibc212), Single-Server Edition (378 GB total memory, 56 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software