SQL commands

Show tables.

list tables [for schema <Schema_Name>];

Describe table.

describe <table>

Show schemas.

Select schemaname from syscat.schemata;.

Current schema.

Values current schema.

NOTE. A typo in schema name - will not cause alarm.

That is, you can change schema into a new one without having to create it first.

Change schema.

set schema <SchemaName>

Set current schema to be used.

SET CURRENT SQLID=’<SchemaName>’;

?need to check how is it different.

Create.

create schema <SchemaName> authorization db2inst2