INFORMATION SCHEMA VIEWS (continued)
VIEW USAGE BASED ON
CONSTRAINT_COLUMN_USAGE Sysobjects, syscolumns, systypes
CONSTRAINT_TABLE_USAGE Sysobjects
DOMAIN_CONSTRAINTS Sysobjects, systypes
DOMAINS Spt_data type_info, systypes, syscom-
ments, sysconfigures, syscharsets
KEY_COLUMN_USAGE Sysobjects, syscolumns, sysreferences,
spt_values, sysindexes
PARAMETERS Sysobjects, syscolumns
REFERENTIAL_CONSTRAINTS Sysreferences, sysindexes, sysobjects
ROUTINE_COLUMNS Sysobjects, syscolumns
ROUTINES Sysobjects, syscolumns
SCHEMATA Sysdatabases, sysconfigures, syscharsets
TABLE_CONSTRAINTS Sysobjects
TABLE_PRIVILEGES Sysprotects, sysobjects
TABLES Sysobjects
VIEW_COLUMN_USAGE Sysobjects, sysdepends
VIEW_TABLE_USAGE Sysobjects, sysdepends
VIEWS Sysobjects, syscomments
Contains a row for each accessible view
Contains a row for each table in the
current database that is used as the
basis for a view
Contains a row for each column in the
database that is used as the basis for
a view
Contains a row for each table in the
current database for which the user has
permissions
Contains a row for each table privilege
granted to or by the current user
Contains a row for each table con-
straint in the current database
Contains a row for each database
that has permissions defined for the
current user
Contains a row for each stored pro-
cedure and function accessible to
the user
Contains a row for each column
returned by table-valued functions
Contains a row for each foreign-key
constraint in the database
Contains a row for each parameter
of a user-defined function accessible
to the current user
Contains a row for each column in
the database that is constrained as
a key
Contains a row for each user-
defined datatype accessible to the
user in the current database
Contains a row for each user-
defined datatype in the current
database that has a rule bound to it
Contains a row for each table in the
current database with a constraint
defined for it
Contains a row for each column in
the current database with a con-
straint defined for it
2627EP2.qxd 8/23/00 1:42 PM Page i
