Do you use prefix sys in table name (Best Practice)?
Updated by Brady Stroud [SSW] 1 year ago. See history
123
<introEmbed
body={<>
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?
Categories
Acknowledgements
Related rules
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.