...
Code Block |
---|
|
DESCRIBE DESCRIBE CATALOG [ EXTENDED] catalogName |
Return the metadata of an existing catalogName
...
Code Block |
---|
|
DROP DATABASE [ IF EXISTS ] [ catalogName.]dataBaseName
[ (RESTRICT|CASCADE)]
|
IF EXISTS
...
Code Block |
---|
|
ALTER
DATABASE [catalogName.]dataBaseName SET DBPROPERTIES (name=value [, name=value]*) |
...
Code Block |
---|
|
USE [ catalogName.] dataBaseName |
...
Code Block |
---|
|
DESCRIBE DESCRIBE DATABASE [ EXTENDED] [ catalogName.] dataBasesName |
...
Code Block |
---|
|
DESCRIBE [ EXTENDED] [[catalogName.] dataBasesName].tableName |
...
Code Block |
---|
|
ALTER TABLE TABLE [[catalogName.] dataBasesName].tableName
REAME TO newTableName
|
Rename an existing table.
Code Block |
---|
|
ALTER TABLE [[catalogName.] dataBasesName].tableName
SET TBLROPERTIES (name=value [, name=value]*) |
...
Code Block |
---|
|
CREATE CREATE FUNCTION FUNCTION [IF NOT EXISTS] [[catalog
NamecatalogName.]databaseName.]functionName AS className. |
...
Code Block |
---|
|
DROP DROP FUNCTION FUNCTION [IF EXISTS] [[catalogName.]databaseName.]functionName. |
...
Code Block |
---|
|
ALTER FUNCTION [IF EXISTS] [
[catalogName.]databaseName.]functionName RENAME TO new_name; |
...