DESCRIBE DATABASE
說明
DESCRIBE DATABASE 陳述式會傳回現有資料庫的元資料。元資料資訊包括資料庫名稱、資料庫註解和檔案系統上的資料庫位置。如果指定選用的 EXTENDED 選項，它會傳回基本元資料資訊和資料庫屬性。 DATABASE 和 SCHEMA 可以互換使用。
語法
{ DESC | DESCRIBE } DATABASE [ EXTENDED ] db_name
參數
-
db_name
指定系統中現有資料庫或現有架構的名稱。如果名稱不存在，會擲回例外狀況。
範例
-- Create employees DATABASE
CREATE DATABASE employees COMMENT 'For software companies';
-- Describe employees DATABASE.
-- Returns Database Name, Description and Root location of the filesystem
-- for the employees DATABASE.
DESCRIBE DATABASE employees;
+-------------------------+-----------------------------+
|database_description_item| database_description_value|
+-------------------------+-----------------------------+
| Database Name| employees|
| Description| For software companies|
| Location|file:/Users/Temp/employees.db|
+-------------------------+-----------------------------+
-- Create employees DATABASE
CREATE DATABASE employees COMMENT 'For software companies';
-- Alter employees database to set DBPROPERTIES
ALTER DATABASE employees SET DBPROPERTIES ('Create-by' = 'Kevin', 'Create-date' = '09/01/2019');
-- Describe employees DATABASE with EXTENDED option to return additional database properties
DESCRIBE DATABASE EXTENDED employees;
+-------------------------+---------------------------------------------+
|database_description_item| database_description_value|
+-------------------------+---------------------------------------------+
| Database Name| employees|
| Description| For software companies|
| Location| file:/Users/Temp/employees.db|
| Properties|((Create-by,kevin), (Create-date,09/01/2019))|
+-------------------------+---------------------------------------------+
-- Create deployment SCHEMA
CREATE SCHEMA deployment COMMENT 'Deployment environment';
-- Describe deployment, the DATABASE and SCHEMA are interchangeable, their meaning are the same.
DESC DATABASE deployment;
+-------------------------+------------------------------+
|database_description_item|database_description_value |
+-------------------------+------------------------------+
| Database Name| deployment|
| Description| Deployment environment|
| Location|file:/Users/Temp/deployment.db|
+-------------------------+------------------------------+