SQLUSA

Microsoft SQL Server 2000 Best Practices

How to the Hungarian convention for naming database objects?

 

The Hungarian software object naming convention was invented by Charles Simonyi (Hungarian refugee from Communism), a former Bill Gates insider, the father of Windows at Microsoft.

Instead of space or underscore(_) separators, first letters of words capitalized within a composite name. Lower case prefixes are used to indicate object class.

Tables: glMaster, glTransaction, glAccount, OrderHeader, OrderDetail, ShipCompany, ProductType, MagazineSubscriptionFulfillment

Views: vSalesHistoryByProduct, vDBUtilizationLog

Functions: fEuropeanDate, fCurrentDate (fn prefix can also be used)

Stored Procedures: apAccountHistory, apAccountSummary (ap stand for accounts payable)

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page