THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Code Block | ||
---|---|---|
| ||
CREATE TABLE [catalog_name.][db_name.]table_name
[(col_name1 col_type1 [IN_LINE_CONSTRAINT] [COMMENT col_comment1],
...,
[OUT_OF_LINE_CONSTRAINT])]
[COMMENT table_comment]
[PARTITIONED BY (col_name1, col_name2, ...)]
[OUT_OF_LINE_CONSTRAINT]:=
[CONSTRAINT constraint_name] ((PRIMARY KEY | UNIQUE) (column, ...)) [[NOT] ENFORCED]
[IN_LINE_CONSTRAINT]:=
[CONSTRAINT constraint_name] (PRIMARY KEY | UNIQUE) [[NOT] ENFORCED]
ALTER TABLE [catalog_name.][db_name.]table_name
ADD (OUT_OF_LINE_CONSTRAINT) |
DROP CONSTRAINT constraint_name
|
Proposed Changes
...