SQL Server: should I use information_schema tables over sys tables?

user_368537 0
Viewed 27313

In SQL Server there is two schemas for metadata:

  • INFORMATION_SCHEMA
  • SYS

I have heard that INFORMATION_SCHEMA tables are based on ANSI standard. When developing e.g. stored procedures, should it be wise to use INFORMATION_SCHEMA tables over sys tables?

metadata sql-server-2008 stored-procedures sql-server sql
4 Answers
Related