Difference between revisions of "Amazon Redshift: CREATE SCHEMA"
Jump to navigation
Jump to search
| (4 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
CREATE SCHEMA AUTHORIZATION username[ QUOTA {quota [MB | GB | TB] | UNLIMITED} ] [ schema_element [ ... ] ] | CREATE SCHEMA AUTHORIZATION username[ QUOTA {quota [MB | GB | TB] | UNLIMITED} ] [ schema_element [ ... ] ] | ||
</pre> | </pre> | ||
| + | |||
| + | CREATE SCHEMA your_schema_name | ||
| + | Output_: CREATE SCHEMA | ||
CREATE SCHEMA your_schema_name AUTHORIZATION your_username | CREATE SCHEMA your_schema_name AUTHORIZATION your_username | ||
| + | == Related == | ||
| + | * [[Amazon Redshift: grant read only provileges to user]] | ||
| + | * <code>[[GRANT USAGE]]</code> and <code>[[GRANT SELECT]]</code> | ||
| + | |||
| + | == Activities == | ||
| + | * Understand visibility to [[schemas]] if you <code>[[GRANT USAGE]]</code> but do not execute <code>[[GRANT SELECT]]</code> | ||
== See also == | == See also == | ||
Latest revision as of 14:43, 28 April 2022
https://docs.aws.amazon.com/es_es/redshift/latest/dg/r_CREATE_SCHEMA.html
CREATE SCHEMA [ IF NOT EXISTS ] schema_name [ AUTHORIZATION username ]
[ QUOTA {quota [MB | GB | TB] | UNLIMITED} ] [ schema_element [ ... ]
CREATE SCHEMA AUTHORIZATION username[ QUOTA {quota [MB | GB | TB] | UNLIMITED} ] [ schema_element [ ... ] ]
CREATE SCHEMA your_schema_name Output_: CREATE SCHEMA
CREATE SCHEMA your_schema_name AUTHORIZATION your_username
Related[edit]
Activities[edit]
- Understand visibility to schemas if you
GRANT USAGEbut do not executeGRANT SELECT
See also[edit]
Advertising:
