The following dbschema flags can display the CREATE EXTERNAL TABLE statement that specify the schema of external tables, including any 'db2' formatting directive or multibyte recordend parameter that is part of the table schema specification:
| Flag | Effect |
|---|---|
| p | Displays the DDL statements to create all the objects in the specified database, including any external tables |
| t table,
ti table |
Displays the DDL statement to create the specified table, which can be an external table |
| t all,
ti all |
Displays the DDL statements to create all the tables in the database |