SqlServer 2005中的数据库名称 [英] Database name in SqlServer 2005

问题描述

你好朋友，



我在SqlServer 2005上制作数据库。



所以，怎么能我为该数据库选择了一个好名字。



请帮助，谢谢。

Hello frnds,

I am making database in SqlServer 2005.

So, how can i choose a good name for that database.

Please help , Thanks.

推荐答案

命名约定在SQL Server的AdventureWorks数据库中使用，展示了许多风格方面的最佳实践。



总结：



•对象名称易于理解

•表名不是复数（用户表不是用户）

•缩写很少，但允许（即数量，Amt等）

•PascalCase专用于某些列名称（即rowguid）除外

•没有下划线

•允许某些关键字（即名称）

•存储过程以usp开头

•函数以ufn开头

你可以在这里找到更多细节：



•AdventureWorks Data Dictio nary

•AdventureWorks中的存储过程

•AdventureWorks中的函数

The naming conventions used in SQL Server''s AdventureWorks database demonstrate many best practices in terms of style.

To summarize:

•Object names are easily understood
•Table names are not pluralized ("User" table not "Users")
•Abbreviations are few, but allowed (i.e. Qty, Amt, etc.)
•PascalCase used exclusively with the exception of certain column names (i.e. rowguid)
•No underscores
•Certain keywords are allowed (i.e. Name)
•Stored procedures are prefaced with "usp"
•Functions are prefaced with "ufn"
You can find more details here:

•AdventureWorks Data Dictionary
•Stored Procedures in AdventureWorks
•Functions in AdventureWorks
One caveat: database naming conventions can be very controversial and most database developers I''ve met have a personal stake in their style. I''ve heard heated arguments over whether a table should be named "OrderHeader" or "OrderHeaders."

这篇关于SqlServer 2005中的数据库名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！