h1.post-title { color:orange; font-family:verdana,Arial; font-weight:bold; padding-bottom:5px; text-shadow:#64665b 0px 1px 1px; font-size:32px; } -->

Pages

SQL Server Naming conventions and Standards

Today , we will discuss about SQL Server Name Conventions and Standards

  1. Table >> tbl >>tblEmployees
  2. Primary Key Constraint >> PK >>PK_EmployeeId
  3. Foreign Key Constraint>> FK >> FK_Employeeid
  4. Unique Key Constraint>> UQ >>UQ_employee_EmailId
  5. Default Constraint >> DF >> DF_Employee_IsActive
  6. Check Constraint >> CHk >> CHK_Employee_DOB
  7. User defined Store Procedure >> usp Eg:usp_Insert_Employee
  8. User Defined Functions >> fn >> fn_CalculateAge
  9. Views >> vw >> vw_OrderDetails
  10. Triggers >> trg >> trg_Del_Employee
  11. Indexes >> IX >>IX_EmployeeEmailId