Today , we will discuss about SQL Server Name Conventions and Standards
- Table >> tbl >>tblEmployees
- Primary Key Constraint >> PK >>PK_EmployeeId
- Foreign Key Constraint>> FK >> FK_Employeeid
- Unique Key Constraint>> UQ >>UQ_employee_EmailId
- Default Constraint >> DF >> DF_Employee_IsActive
- Check Constraint >> CHk >> CHK_Employee_DOB
- User defined Store Procedure >> usp Eg:usp_Insert_Employee
- User Defined Functions >> fn >> fn_CalculateAge
- Views >> vw >> vw_OrderDetails
- Triggers >> trg >> trg_Del_Employee
- Indexes >> IX >>IX_EmployeeEmailId