描述架構
適用于: Databricks SQL Databricks Runtime
傳回現有架構的中繼資料。
中繼資料資訊包括檔案系統上架構的名稱、批註和位置。
如果指定選擇性 EXTENDED
選項,也會傳回架構屬性。
雖然 和 的使用 SCHEMA
是可交換的, SCHEMA
但最好 DATABASE
使用 。
語法
{ DESC | DESCRIBE } SCHEMA [ EXTENDED ] schema_name
參數
- schema_name:系統中現有架構的名稱 (架構) 。 如果名稱不存在,則會擲回例外狀況。
例子
-- Create employees SCHEMA
> CREATE SCHEMA employees COMMENT 'For software companies';
-- Describe employees SCHEMA.
-- Returns Database Name, Description and Root location of the filesystem
-- for the employees SCHEMA.
> DESCRIBE SCHEMA employees;
database_description_item database_description_value
------------------------- -----------------------------
Database Name employees
Description For software companies
Location file:/you/Temp/employees.db
-- Create employees SCHEMA
> CREATE SCHEMA employees COMMENT 'For software companies';
-- Alter employees schema to set DBPROPERTIES
> ALTER SCHEMA employees SET DBPROPERTIES ('Create-by' = 'Kevin', 'Create-date' = '09/01/2019');
-- Describe employees SCHEMA with EXTENDED option to return additional schema properties
> DESCRIBE SCHEMA EXTENDED employees;
database_description_item database_description_value
------------------------- ---------------------------------------------
Database Name employees
Description For software companies
Location file:/you/Temp/employees.db
Properties ((Create-by,kevin), (Create-date,09/01/2019))
-- Create deployment SCHEMA
> CREATE SCHEMA deployment COMMENT 'Deployment environment';
-- Describe deployment.
> DESCRIBE SCHEMA deployment;
database_description_item database_description_value
------------------------- ------------------------------
Database Name deployment
Description Deployment environment
Location file:/you/Temp/deployment.db