UNLOAD SINGLE TABLE

Description

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

Syntax

Grammar Railroad diagram

unloadSingleTable ::=
  'UNLOAD' 'SINGLE' 'TABLE' tableNames
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