Information Schema is the part of the SQL-92 standard which
exposes the metadata of the database. In SQL server a set of views are created
in each of the database which exposes the metadata of the database. The
information schema is kept in a separate schema - information schema - which
exists in all databases, but which is not included in the search path by
default. It is implemented as a set of views returning specially defined data
types as required by the standard. The access rights of these views do not fall
under the login type "dbo." Using Information Schema we can get the
information about tables, views, constraints, etc.