Do you use prefix sys in table name (Best Practice)?

Last updated by Tiago Araújo [SSW] almost 3 years ago.See history

Don't use sys as a prefix for Access tables. Some developers use this for system tables etc. SQL Server uses tables with this prefix and it becomes confusing. We recommend system tables start with zs - E.g. zsUsers

See our Rules to Better SQL Server Databases - Do you add zs prefix to system tables?

We open source. Powered by GitHub