SHOW CREATE SCHEMA

Synopsis

1. SHOW CREATE SCHEMA schema_name

Description

Show the SQL statement that creates the specified schema.

Examples

Show the SQL that can be run to create the sf1 schema:

1. SHOW CREATE SCHEMA hive.sf1;

1. Create Schema
2. -----------------------------------------
3. CREATE SCHEMA hive.sf1
4. WITH (
5. location = 'hdfs://localhost:9000/user/hive/warehouse/sf1.db'
6. )
7. (1 row)

See Also

CREATE SCHEMA