Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. SQL Server
  3. Question
SQL Server

Why INFORMATION_SCHEMA views should not be used to determine the schema of an object?

Asked by Bhushan Bhad Apr 9, 2021 1.1K views 1 answer
Share

About this question

According to MS-DOCS about System information schema views, the schema columns definition have a warning note that says: ** Important ** Do not use INFORMATION_SCHEMA views to determine the schema of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view. Why can't INFORMATION_SCHEMA views be used to determine the schema of an object? Is this information erroneous?What is INFORMATION_SCHEMA SQL server?

 

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest SQL Server Blogs

Guides, tips and career advice on SQL Server from JanBask experts.