Syntax Elements - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

Locking Object

 

Syntax Element …

Specifies …

DATABASE

Optional keyword to indicate the type of object to lock is a database.

database_name

Name of the database or user to be locked.

TABLE

Optional keyword to indicate the type of object to lock is a table.

table_name

Name of the base table to be locked.

VIEW

Optional keyword to indicate the type of object to lock is a view.

view_name

Name of the view to be locked.

ROW

Optional keyword specifying rowhash or rowkey level for locking in accordance with the defining statement. See “Using LOCKING ROW” on page 396.