SQL Server schema naming convention

11
votes

Are there any industry standard naming conventions for naming schemas in SQL Server?

Unfortunately a few reserved words such as admin describe my planned schemas the most clearly. To get around this I have been debating on making the schema names plural, but in a way that doesn't make sense, and will cause an issue with the Products.Products schema and table.

So I was wondering if there was any clear convention that Microsoft or the industry uses?

1
sql-serverschemanaming-conventions
Since this would be extremely dependent on the underlying data, your design and requirements, no. You'll find best practices of not using reserved words but what you name it would be pretty much up to the creator. Personally, keep it clear and simple IMHO. - scsimon
one idea : put the word "schema" as a suffix. AdminSchema, LookupSchema, etc ,etc. - granadaCoder

1 Answers

12
votes

I found this reference for SQL Server Name Conventions

SQL Server Name Convention and T-SQL Programming Style

It says to use lowercase and no plurals in schemas

enter image description here