Toad World Blog

#0401 – SQL Server – Script to validate object naming convention

Mar 5, 2017 9:30:28 PM by Nakul Vachhrajani

When database development is done using the graphical (GUI) tools in the SQL Server Management Studio (SSMS) or via simple scripts, they often fail to specify a name to each individual constraint. This script can help the team validate object naming conventions.

Tags: SQL Server

Nakul Vachhrajani

Written by Nakul Vachhrajani

Nakul Vachhrajani is a SQL Server MCTS, TOGAF certified Technical Architect with Capgemini (formerly IGATE) having a total IT experience of more than 12 years. He specializes in Data Quality & Management, data migrations and integration.

Nakul is an active blogger, and has been a guest columnist for and Nakul presented a webcast on the “Underappreciated Features of Microsoft SQL Server” at the Microsoft Virtual Tech Days Exclusive Webcast series (May 02-06, 2011) on May 06, 2011. He is also the author of a research paper on Database upgrade methodologies, which was published in a CSI journal, published nationwide.

In addition to his passion about SQL Server, Nakul also contributes to the academia out of personal interest. He visits various colleges and universities as an external faculty to judge project activities being carried out by the students.

A list of all my publications is available on my LinkedIn Profile.

Disclaimer: The opinions expressed herein are his own personal opinions and do not represent his employer’s view in anyway.