sp_chgattribute

The pnt_locking table attribute enables and disables partition level locking with sp_chgattrbute. By default, partition locking is disabled.

Syntax

sp_chgattribute  objectname, 'ptn_locking’, value

Parameters

objectname – is the name of the table on which to change ptn_locking.
ptn_locking – set to 1 to enable and 0 to disable partition-level locking.

Examples

Example 1 – This example enables partition-level locking for the authors table:
```
sp_chgattribute authors, "ptn_locking", 1
```
Example 2 – This example disables partition-level locking for the authors table:
```
sp_chgattribute authors, "ptn_locking", 0
```

Permissions

Only the object owner can execute sp_chgattribute.

Parent topic: Changed System Procedures

Created April 2, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com