Deprecated system tables in MSSQL 2005

  • With every version of SQL Server, Microsoft comes out with new features and retires some others.
  • When they announce that a feature will not be available in the next version, it is called: deprecated.
  • Microsoft announces the deprecated features. These deprecated features are still available for the current version, but these features are removed on the next version of MSSQL. You will have to change your queries/programs if you want them to run with the next version.
  • With MSSQL 2005, Microsoft announced that a whole bunch of system tables are deprecated, meaning that these tables will be gone in MSSQL 2008.

Applies to:

  • Microsoft SQL Server 2005

Deprecated system tables

Here is the list of the deprecated system tables:

  1. sysaltfiles
  2. syscacheobjects
  3. syscolumns
  4. syscomments
  5. sysconfigures
  6. sysconstraints
  7. syscurconfigs
  8. sysdatabases
  9. sysdepends
  10. sysdevices
  11. sysfilegroups
  12. sysfiles
  13. sysforeignkeys
  14. sysfulltextcatalogs
  15. sysindexes
  16. sysindexkeys
  17. syslockinfo
  18. syslogins
  19. sysmembers
  20. sysmessages
  21. sysobjects
  22. sysoledbusers
  23. sysopentapes
  24. sysperfinfo
  25. syspermissions
  26. sysprocesses
  27. sysprotects
  28. sysreferences
  29. sysremotelogins
  30. sysservers
  31. systypes

They have been replaced with the following tables: 

sysaltfiles          becomes: sys.sysaltfiles
syscacheobjects      becomes: sys.syscacheobjects
syscolumns           becomes: sys.syscolumns
syscomments          becomes: sys.syscomments
sysconfigures        becomes: sys.sysconfigures
sysconstraints       becomes: sys.sysconstraints
syscurconfigs        becomes: sys.syscurconfigs
sysdatabases         becomes: sys.sysdatabases
sysdepends           becomes: sys.sysdepends
sysdevices           becomes: sys.sysdevices
sysfilegroups        becomes: sys.sysfilegroups
sysfiles             becomes: sys.sysfiles
sysforeignkeys       becomes: sys.sysforeignkeys
sysfulltextcatalogs  becomes: sys.sysfulltextcatalogs
sysindexes           becomes: sys.sysindexes
sysindexkeys         becomes: sys.sysindexkeys
syslockinfo          becomes: sys.syslockinfo
syslogins            becomes: sys.syslogins
sysmembers           becomes: sys.sysmembers
sysmessages          becomes: sys.sysmessages
sysobjects           becomes: sys.sysobjects
sysoledbusers        becomes: sys.sysoledbusers
sysopentapes         becomes: sys.sysopentapes
sysperfinfo          becomes: sys.sysperfinfo
syspermissions       becomes: sys.syspermissions
sysprocesses         becomes: sys.sysprocesses
sysprotects          becomes: sys.sysprotects
sysreferences        becomes: sys.sysreferences
sysremotelogins      becomes: sys.sysremotelogins
sysservers           becomes: sys.sysservers
systypes             becomes: sys.systypes
  • The existing tables name have simply changed from itself to sys. + itself.
  • syscolumns becomes: sys.syscolumns and systypes becomes: sys.systypes and so on...