Suggestions about naming conventions ?

01-16-08, 06:19 PM

M. Simioni

Hi all,
i'm going to design a new big database, and i want to follow some
guideline about naming conventions.

I always designed my databases choosing myself the naming convention.

Now i'm asking if theere is some guideline, perhaps a Microsoft
Consulting standard, that i can follow to design my database?
I mean, i have to choose names for Tables, Columns, Views, Stored
Procedures.
I want to know if it is better to call a column "DeviceName", or
"DEVNAME", or "VCH_DEVNAME" to identify the type, and so on.

What are the most used guidelines followed by microsoft certified
consultants? Can you provide me some link?

Thank you very much i.a.,

Marco

01-16-08, 06:34 PM

sloan

Here is a suggestion.

http://www.ssw.com.au/ssw/Standards/...ectNaming.aspx

I personally use "usp" for User Stored Procedures.

exec dbo.uspCustomerGetAll

"M. Simioni" <m.simioni> wrote in message
news:2356
[..]

01-16-08, 07:42 PM

--CELKO--

>> I want to follow some guideline about naming conventions. <<

Get a bulk order of SQL PROGRAMMING STYLE and use it as the "house
style" for your company. It is based on ISO-11179 rules and a few
decades of human factors research in typography, software engineering,
etc.

But the most important feature is that if anyone does not like it, you
can blame me!

Similar Threads
Naming Conventions Hi, Could someone tell me where I can find Microsoft recommended naming conventions to be used in database design?
Naming Conventions Hi all, I'm quite new to Ruby. One of the things I try to get when I learn a new language are naming conventions. I hate to write, for instance, Java code that looks like...
Naming Conventions Hello, I´m looking for VB Naming Conventions documents. Could someone help me ? TIA, Fernando
naming conventions Here are some vocabulary / method naming questions. What verbs would you use to describe the following: 1. taking data and putting it in GUI Components for display. 2....
CLS naming conventions Does anyone know the correct naming conventions for CLS compliant code ? The doc points to a really obscure and difficult to digest document on the web about Unicode names,...