Saturday, 10 September 2016

Database Table and Column Naming Conventions

We have worked with many different databases over the years, and we have seen many different naming conventions for tables and columns. Some of the naming conventions we have encountered are great, and others are simply awful.

If you are curious to know what conventions are followed by the database development team at InSite, one of our developers has posted a great article on the topic.

SQL Server Table and Column Naming Conventions

The article describes standard naming conventions for tables and columns, and it provides code that leverages the conventions to do some useful things like dependency visualization and foreign key constraint validation.

No comments:

Post a Comment