schemata
The schemata view provides information about databases. This view is read-only. All users have the read permission on this view.
|
Name |
Type |
Description |
|---|---|---|
|
CATALOG_NAME |
varchar(512) |
Name of the database. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive. |
|
SCHEMA_NAME |
varchar(64) |
Name of the schema. When lower_case_table_names is set to 0, the value of this column is case-sensitive. When lower_case_table_names is set to 1, the value of this column is case-insensitive. |
|
DEFAULT_CHARACTER_SET_NAME |
varchar(32) |
Name of the default character set of the schema. |
|
DEFAULT_COLLATION_NAME |
varchar(32) |
Default collation of the schema. |
|
SQL_PATH |
varchar(32) |
It is always null. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
