15.00 - Locks and Concurrency - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Locks and Concurrency

For an ALTER TABLE statement, a WRITE lock is placed on the base table being altered. Teradata Database also places a table‑level lock on DBC.AccessRights, but removes it before the physical row altering phase of the process to enhance ALTER TABLE performance.

Because of the overhead required to alter a base table for dropped or added columns, you should establish a final form for the table before it contains very many rows. When a very large table is altered, it can be unavailable to other users for a long time.