The locking schemes in Adaptive Server provide the flexibility to choose the best locking scheme for each table in an application and to adapt the locking scheme for a table if contention or performance requires a change. The tools for specifying locking schemes are:
sp_configure – specifies a server-wide default locking scheme
create table – specifies the locking scheme for newly created tables
alter table – changes the locking scheme for a table to any other locking scheme
select into – specifies the locking scheme for a table created by selecting results from other tables
