INFORMATION_SCHEMA vs sysobjects

by

The INFORMATION_SCHEMA is part of the SQL-92 standard, so it’s not likely to change nearly as often as sysobjects.

The views provide an internal, system table-independent view of the SQL Server metadata. They work correctly even if significant changes have been made to the underlying system tables.

You are always much better off querying INFORMATION_SCHEMA, because it hides the implementation details of the objects in sysobjects.

More Related Contents:

  1. SQL Server query to find all permissions/access for all users in a database
  2. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  3. Why use the INCLUDE clause when creating an index?
  4. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  5. Is it possible to force row level locking in SQL Server?
  6. Regular Expressions in SQL Server servers?
  7. SQL Server GUID sort algorithm. Why?
  8. What happens to the primary key Id when it goes over the limit?
  9. Drop primary key using script in SQL Server database [duplicate]
  10. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  11. SQL Server recursive query
  12. nvarchar(max) vs NText
  13. “Prevent saving changes that require the table to be re-created” negative effects
  14. What are row, page and table locks? And when they are acquired?
  15. Table Valued Function Killing My Query Performance
  16. Is it possible to write single query on two table which are not connected to each other?
  17. If condition in SQL Server 2008
  18. Which are more performant, CTE or temporary tables?
  19. Using RegEx in SQL Server
  20. SqlServer: Login failed for user
  21. SQL Server: combining multiple rows into one row
  22. SQL Server error on update command – “A severe error occurred on the current command”
  23. SQL server schema and default schema
  24. SQL Server ON DELETE Trigger
  25. FOR XML PATH(”): Escaping “special” characters
  26. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  27. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  28. Why is casting from float to varchar being rounded in SQL Server?
  29. In SQL Server, how can I find everywhere a column is referenced?
  30. Using Full-Text Search in SQL Server 2008 across multiple tables, columns

Leave a Comment