DEVELOPMENT SERVER
Rules to Better Access Databases

SSW Rules/Reporting Solutions/Rules to Better Access Databases/Do you use prefix sys in table name (Best Practice)?

Rule #12

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

v2.0 Posted at 20/10/2010 7:56 PM by system

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 eg. zsUsers

Upsizing PRO will check this rule

See our Rules to Better SQL Server Databases - Do you add zs prefix to table name?

Tell a Friend

Do you like this rule?

Do you follow this rule?

« Back #11 Do you use a unique index a ...

#13 Do you always have version ... Next »

DEVELOPMENT SERVER
Rules to Better Access Databases

Related Links

Acknowledgements

Our experience

How to get started

if (document.location.hostname == "vm-spdev-589") $("#serverTag").show(); DEVELOPMENT SERVER Rules to Better Access Databases

Related Links

Acknowledgements

Our experience

How to get started

DEVELOPMENT SERVER
Rules to Better Access Databases