Search notes:

SQL Server: INFORMATION_SCHEMA

INFORMATION_SCHEMA is the ANSI way do query meta data about objects in SQL databases. SQL server implements them as views that (usually?) access tables in the sys schema.
INFORMATION_SCHEMA is one of the four predefined schemas that cannot be deleted.

Select all views in INFORMATION_SCHEMA

The following query allows to find all views in the INFORMATION_SCHEMA schema:
select
  v.name
from
  sys.schemas     s join
  sys.all_views   v on s.schema_id = v.schema_id
where
  s.name = 'INFORMATION_SCHEMA'
order by
  v.name;
Github repository about-MSSQL, path: /administration/schemas/INFORMATION_SCHEMA/select-views.sql
It returns:

See also

schemas
Oracle: INFORMATION_SCHEMA

Index