SQL Server Lock Type and Mode

SQL Server Locks are used to restrict the user and access and prevent the unautorised access to data and at the same time.

SQL Server have folowing Lock Type-

1- RID
2- Key
3- Page
4- Extent
5- Table
6- DB

SQL Server have folowing Mode Type-

1- Shared (S)
2- Update (U)
3- Exclusive (X)
4- Intent
5- Schema
6- Bulk Update (BU)