DF054: A deprecated system table or view is used.
The topic describes the DF054 T-SQL code analysis rule.
Category
Deprecated
Message
A deprecated system table or view is used.
Description
It is recommended to avoid using deprecated system tables or views.
A list of tables to be deprecated is as follows:
- sysaltfiles
- syscacheobjects
- syscolumns
- syscomments
- sysconfigures
- sysconstraints
- syscurconfigs
- sysdatabases
- sysdepends
- sysdevices
- sysfilegroups
- sysfiles
- sysforeignkeys
- sysfulltextcatalogs
- sysindexes
- sysindexkeys
- syslockinfo
- syslogins
- sysmembers
- sysmessages
- sysobjects
- sysoledbusers
- sysopentapes
- sysperfinfo
- syspermissions
- sysprocesses
- sysprotects
- sysreferences
- sysremotelogins
- sysservers
- systypes
- sysusers
- sql_dependencies
- numbered_procedure_parameters
- numbered_procedures
- database_principal_aliases
Noncompliant code example
SELECT * FROM sys.sysobjects
GO
Compliant solution
SELECT * FROM sys.objects
GO
Want to Find out More?
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?