Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Androidâ„¢ device!
Free
Faster access than browser!
 

Information schema

Index Information schema

In relational databases, the information schema (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. [1]

13 relations: American National Standards Institute, Column (database), H2 (DBMS), HSQLDB, MySQL, Oracle Database, Oracle metadata, PostgreSQL, Relational database, SQL*Plus, Stored procedure, Table (database), View (SQL).

American National Standards Institute

The American National Standards Institute (ANSI) is a private non-profit organization that oversees the development of voluntary consensus standards for products, services, processes, systems, and personnel in the United States.

New!!: Information schema and American National Standards Institute · See more »

Column (database)

In a relational database, a column is a set of data values of a particular simple type, one value for each row of the database.

New!!: Information schema and Column (database) · See more »

H2 (DBMS)

H2 is a relational database management system written in Java.

New!!: Information schema and H2 (DBMS) · See more »

HSQLDB

HSQLDB (Hyper SQL Database) is a relational database management system written in Java.

New!!: Information schema and HSQLDB · See more »

MySQL

MySQL ("My S-Q-L") is an open-source relational database management system (RDBMS).

New!!: Information schema and MySQL · See more »

Oracle Database

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

New!!: Information schema and Oracle Database · See more »

Oracle metadata

Oracle Database provides information about all of the tables, views, columns, and procedures in a database.

New!!: Information schema and Oracle metadata · See more »

PostgreSQL

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

New!!: Information schema and PostgreSQL · See more »

Relational database

A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970.

New!!: Information schema and Relational database · See more »

SQL*Plus

SQL*Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers.

New!!: Information schema and SQL*Plus · See more »

Stored procedure

A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS).

New!!: Information schema and Stored procedure · See more »

Table (database)

A table is a collection of related data held in a structured format within a database.

New!!: Information schema and Table (database) · See more »

View (SQL)

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.

New!!: Information schema and View (SQL) · See more »

Redirects here:

Information Schema.

References

[1] https://en.wikipedia.org/wiki/Information_schema

OutgoingIncoming
Hey! We are on Facebook now! »