[DOC] : INFORMATION_SCHEMA topics should warn that the views are incomplete - by AaronBertrand

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 686121 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 8/29/2011 8:59:05 PM
Access Restriction Public


We should be encouraging users to use the catalog views. Many hold on to INFORMATION_SCHEMA for portability or standards reasons, but they may not be aware that the views have not been updated for new features (a couple of examples off the top of my head: filtered indexes and included columns).

The main documentation page for the I_S views contains a couple of warnings:


Some changes have been made to the information schema views that break backward compatibility. These changes are described in the topics for the specific views.

Information schema views provide an internal, system table-independent view of the SQL Server metadata. Information schema views enable applications to work correctly although significant changes have been made to the underlying system tables. The information schema views included in SQL Server comply with the ISO standard definition for the INFORMATION_SCHEMA.

While these are an indirect admission that the views are not complete, I suggest a more direct confirmation. At the very least, the second note should be expanded to explicitly state that the views have not been, and may continue to not be, updated for all new features. The note should also be included on all INFORMATION_SCHEMA view topics.
Sign in to post a comment.
Posted by Microsoft on 8/29/2012 at 3:42 PM
Hi Aaron,

Thanks for your feedback. I updated the topic by adding "INFORMATION_SCHEMA views could be incomplete since they are not updated for all new features" to the alert.
The alert now reads:
Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of an object is to query the sys.objects catalog view. INFORMATION_SCHEMA views could be incomplete since they are not updated for all new features.
Posted by Microsoft on 8/31/2011 at 4:55 PM
Thanks for the suggestion, Aaron. I've linked this item to your other related item so that they get reviewed/addressed together.

Gail Erickson
SQL Server Documentation Team