Does anyone know the location of an offical (Microsoft if possible) document that shows the best practices for databse design?
For instance what to call tables now schema's exist?
Should it be
Countries
LookCountry
Geography.Country
Geography.Countries
What about Views and Stored procedures? prefix with VW_ sp_ or some alternative?
Thanks
I have never seen any Microsoft Official document on this. But SQL Gurn Vyas has his own view which is very helpful. Refer these links
http://vyaskn.tripod.com/object_naming.htm
http://vyaskn.tripod.com/coding_conventions.htm
Do not use SP_ for procedure since those are there for system storedprocdure. Ucan have USP(User Storedprocedure) its again depends. I never uses "_" (unserscore) in my tablename. It may be easy to read but difficult to use.
Madhu
No comments:
Post a Comment