Restricting database objects

In an organization, you might have more than one developer creating a SQL script for the project. It is mandatory to maintain some kind of naming convention rules to maintain consistency and readability. There is a chance that a mistake or lack of co-ordination among developers may occur, so it would be great if we could handle the rules for this kind of naming convention forcefully, by some policy.

Naming the object in the right way is not only necessary for maintaining consistency and readability but also impacts performance, sometimes. So, to avoid performance penalties, restrict the naming convention for database objects. Generally, SP_ is the prefix used for stored procedures in SQL Server (system stored procedure), but it has been observed that many developers tend to use it for their own customized stored procedure, too. It has little overhead in terms of performance.

We are going to learn how to restrict certain names for the database objects. You can...