SHOW DIRECTORY Syntax
Only one directory can be named; a comma-separated list will return
an error. To output a directory’s detail instead of its DDL, see
LIST DIRECTORY.
Parameters
<directory name>
<directory name>
Name of the existing directory whose DDL will be output.
Use
*, or omit the name entirely, to output the DDL of all
directories.Response
The response toSHOW DIRECTORY is a single-column result set:
Examples
To output the DDL for a directory,kdata:
SHOW DIRECTORY Example
SHOW DIRECTORY Output
SHOW DIRECTORIES (All Directories) Example
The DDL for a home directory is
emitted with an empty directory name, the owning user being given in a
create_home_directory option instead.