locking_clause - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
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.