Which of the following is not a SQL Server INFORMATION_SCHEMA view ?
A. INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
B. INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
C. INFORMATION_SCHEMA.KEY_COLUMN_USAGE
D. sys.dm_exec_connections
Answer:A
Which of the following is not a SQL Server INFORMATION_SCHEMA view ?
A. INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE B. INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS C. INFORMATION_SCHEMA.KEY_COLUMN_USAGE D. sys.dm_exec_connections
Explanation:The INFORMATION_SCHEMA views allow you to retrieve metadata about the objects within a database. These views can be found in the master database under Views / System Views and be called from any database in your SQL Server instance.