locking_clause - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

For more information about the LOCKING clause, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.

LOCKING
The type of lock to be placed on a database, table, view, or row hash. This setting will override any default lock placed on that object by the system. See Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 , and Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.

item_to_lock

DATABASE
A lock is to be placed at the database level for this view definition.
database_name
user_name
Name of the database or user that is to be locked for this view definition.
TABLE
Specifies that a lock is to be placed at the table level for this view definition.
database_name
user_name
Name of the containing database or user for table_name if other than the current database or user.
table_name
Name of a user base table to be locked for this view definition.
VIEW
Specifies that a lock is to be placed at the view level for this view definition.
database_name
user_name
Name of the containing database or user for view_name if something other than the current database or user.
view_name
Name of a view to be locked for this view definition.
ROW
Specifies that a lock is to be placed at the row hash level for this view definition.
lock_type
The type of lock to be placed when accessing base tables through this view.
MODE
An optional keyword.
NOWAIT
Specifies that if the indicated lock cannot be obtained, the request using this view should be aborted.
This option can prevent a situation where a request is waiting for resources, possibly tying up other resources in the process of waiting for a lock to become available.