Click here to Skip to main content
15,885,216 members
Articles / Database Development / SQL Server

SQL Server Table and Column Naming Conventions

Rate me:
Please Sign up or sign in to vote.
4.80/5 (54 votes)
30 Dec 2015CPOL15 min read 229.4K   761   85  
This article describes standard naming conventions for tables and columns, and it provides code that leverages the conventions to visualize dependencies and automatically validate and generate foreign key constraints.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Chief Technology Officer Shift iQ
Canada Canada
I have been building software systems for more than 20 years, working for organizations that range from small non-profit associations in my local community to global Fortune 500 enterprises.

I specialize in the design and implementation of online database solutions. My work-related research interests include software design patterns and information architecture.

Comments and Discussions