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.