Fix unresolved reference to object [INFORMATION_SCHEMA].[TABLES]

Add a database reference to master:

1. Under the project, right-click References.
2. Select Add database reference....
3. Select System database.
4. Ensure master is selected.
5. Press OK.

Note that it might take a while for VS to update.

from : https://stackoverflow.com/questions/18096029/unresolved-reference-to-object-information-schema-tables