Data Lake Compute
- Getting Started
- Operation Guide
- Console Operation Introduction
- Data Development and Exploration
- Data Exploration
- Data Query Task
- Resource Management
- Engine Management
- SuperSQL Engine
- Standard Engine
- Resource Group
- Private Connection
- Storage Configuration
- Ops Management
- Insight Management
- System Management
- User and Permission Management
- Monitoring and Alarms
- Development Guide
- System Restraints
- Client Access
- JDBC Access
- Practical Tutorial
- SQL Statement
- SuperSQL Statement
- Unified Statement
- DDL Statement
- ALTER TABLE
- DML Statement
- DQL Statement
- Iceberg Table Statement
- API Documentation
- Making API Requests
- Data Table APIs
- Task APIs
- Metadata APIs
- Service Configuration APIs
- Permission Management APIs
- Data Source Connection APIs
- Data Optimization APIs
- Data Engine APIs
- General Reference
- Operation Guide on Connecting Third-Party Software to DLC
DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementCREATE DATABASE
CREATE DATABASE
Last updated: 2024-08-07 17:10:06
Description
Supported engines: Presto and SparkSQL
Purpose: Create a database, or specify or change the storage location of a table or partitioned table.
Statement
CREATE {DATABASE|SCHEMA} [IF NOT EXISTS] database_name[COMMENT 'database_comment'][WITH DBPROPERTIES ('property_name' = 'property_value') [, ...]]
Parameter
DATABASE|SCHEMA: Specify the database or schema.database_name: Database name.database_comment: Database comment.[WITH DBPROPERTIES ('property_name' = 'property_value') [, ...]]: Configure database parameters using key-value pairs.Example
Create database
db only if database with same name doesn't exist.CREATE DATABASE IF NOT EXISTS db;
Create database
db only if database with same name doesn't exist with Comment and Database Properties.CREATE DATABASE dbCOMMENT 'db1_name'WITH DBPROPERTIES('k1' = 'v1','k2' = 'v2');
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No