Rules

Secret ingredients to quality software

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

Last updated by Tiago Ara├║jo [SSW] on 14 Jun 2021 10:40 pm (6 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?

Adam CoganAdam Cogan

We open source. Powered by GitHub