4D v14

UNLOCK TABLE

Home

4D SQL Reference
- SQL Commands
- - SQL Commands
  - SELECT
  - INSERT
  - UPDATE
  - DELETE
  - CREATE DATABASE
  - USE DATABASE
  - ALTER DATABASE
  - CREATE TABLE
  - ALTER TABLE
  - DROP TABLE
  - CREATE INDEX
  - DROP INDEX
  - LOCK TABLE
  - UNLOCK TABLE
  - EXECUTE IMMEDIATE
  - CREATE SCHEMA
  - ALTER SCHEMA
  - DROP SCHEMA
  - CREATE VIEW
  - DROP VIEW
  - GRANT
  - REVOKE
  - REPLICATE
  - SYNCHRONIZE

Home

4D v14

4D SQL Reference

SQL Commands

UNLOCK TABLE



	UNLOCK TABLE sql_name

Description

The UNLOCK TABLE command is used to unlock a table that has previously been locked via the LOCK TABLE command. It will not work if it is passed within a transaction or if it is used on a table that is locked by another process.

Example

This command removes the lock on the MOVIES table:

UNLOCK TABLE MOVIES

PROPERTIES

Product: 4D
Theme: SQL Commands

SEE ALSO

ALTER TABLE
LOCK TABLE

ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)

Page generated on 2014-11-28 - 16:34:42

On-line version