Should we use system tables or information schema views to retrieve metadata if both give the same results? Please explain why.

Tags:
Meta data
SQL Server
SQL Server 2005
SYSTEM TABLESPACE
Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?

Answer Wiki

Thanks. We'll let you know when a new response is added.

In SQL Server 2000 you should be using the INFORMATION_SCHEMA views. In SQL Server 2005 and up you should refer to the system views. Starting in SQL Server 2005 there are no more system tables. Everything is held within these system catalog views. They are the views which are in the sys schema.

Eventually the INFORMATION_SCHEMA views will be removed from SQL Server, so it’s best to begin using the system catalog views now.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following