Summary

Although you can choose among many schemes, it is well worth the initial effort and time to develop standards. Standards lower development costs and mistakes and provide an infrastructure and framework for future development.

There are a number of SQL Server names that need to be defined in your environment. Too many SQL Server customers approach development without established standards. This is likely to result in costly rework to bring an existing system up to standard after the standards are defined. Sometimes, customers decide not to change the database because of the cost of conversion. This results in a nonstandard SQL Server implementation in their environment.

It is important to define naming standards as early as possible and ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.