UNLOAD SINGLE TABLE

Description

The UNLOAD SINGLE TABLE syntax is used to unload single table.

Syntax

unloadSingleTable ::=
  'UNLOAD' 'SINGLE' 'TABLE' tableNames
  | 'UNLOAD' 'SINGLE' 'TABLE' '*'
  | 'UNLOAD' 'ALL' 'SINGLE' 'TABLES'

tableNames ::=
  tableName (',' tableName)*

tableName ::=
  identifier

Supplement

• Unlike loading, only the table name needs to be specified when unloading a single table

Example

• Unload specified single table

UNLOAD SINGLE TABLE t_single;

• Load all single tables

UNLOAD SINGLE TABLE *;
-- or
UNLOAD ALL SINGLE TABLES;

Reserved word

UNLOAD, SINGLE, TABLE, ALL, TABLES

Related links

• Reserved word