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 the CREATE VIEW REPLACE VIEW topic “Views and the LOCKING Request Modifier” in 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.