DESCRIBE SCHEMA
적용 대상:
Databricks SQL Databricks Runtime
기존 schema메타데이터를 반환합니다.
메타데이터 정보에는 파일 시스템 상의 schema의 이름, 주석 및 위치가 포함됩니다.
선택적 EXTENDED 옵션을 지정하면 schema 속성도 반환됩니다.
SCHEMA 및 DATABASE의 사용은 서로 교환할 수 있지만 SCHEMA가 선호됩니다.
구문
{ DESC | DESCRIBE } SCHEMA [ EXTENDED ] schema_name
Parameters
- schema_name: 시스템의 기존 schema(schema)의 이름입니다. 이름이 없으면 예외가 throw됩니다.
예제
-- 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