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;
It returns:
- CHECK_CONSTRAINTS
- COLUMN_DOMAIN_USAGE
- COLUMN_PRIVILEGES
- COLUMNS
- CONSTRAINT_COLUMN_USAGE
- CONSTRAINT_TABLE_USAGE
- DOMAIN_CONSTRAINTS
- DOMAINS
- KEY_COLUMN_USAGE
- PARAMETERS
- REFERENTIAL_CONSTRAINTS
- ROUTINE_COLUMNS
- ROUTINES
- SCHEMATA
- SEQUENCES
- TABLE_CONSTRAINTS
- TABLE_PRIVILEGES
- TABLES
- VIEW_COLUMN_USAGE
- VIEW_TABLE_USAGE
- VIEWS