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

Last updated by Brady Stroud [SSW] about 2 months 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