ql/src/test/queries/clientpositive/show_create_database.q

CREATE DATABASE some_database comment 'for show create db test' WITH DBPROPERTIES ('somekey'='somevalue');
SHOW CREATE DATABASE some_database;