Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-alter-schema below:

ALTER SCHEMA | Databricks Documentation

> CREATE SCHEMA inventory;


> ALTER SCHEMA inventory SET DBPROPERTIES ('Edited-by' = 'John', 'Edit-date' = '01/01/2001');


> DESCRIBE SCHEMA EXTENDED inventory;
 database_description_item                 database_description_value
 
             Database Name                                  inventory
               Description
                  Location    file:/temp/spark-warehouse/inventory.db
                Properties ((Edit-date,01/01/2001), (Edited-by,John))


> ALTER SCHEMA inventory OWNER TO `alf@melmak.et`


> ALTER SCHEMA test SET TAGS ('tag1' = 'val1', 'tag2' = 'val2', 'tag3' = 'val3');


> ALTER SCHEMA test UNSET TAGS ('tag1', 'tag2', 'tag3');


> ALTER SCHEMA my_schema ENABLE PREDICTIVE OPTIMIZATION;


> ALTER SCHEMA my_schema DEFAULT COLLATION UNICODE_CI_AI;

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4