THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
Status
Current state: "Under Discussion"
Discussion thread: http://apache-flink-mailing-list-archive.1008284.n3.nabble.com/DISCUSS-Primary-keys-in-Table-API-td35138.html
JIRA: here (<- link to https://issues.apache.org/jira/browse/FLINK-XXXX)
...
| Page properties | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Please keep the discussion on the mailing list rather than commenting on the wiki (wiki discussions get unwieldy fast).
...
| 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]
-- possible extension, not part of the FLIP, as we do not have alter statements
ALTER TABLE [catalog_name.][db_name.]table_name
ADD (OUT_OF_LINE_CONSTRAINT) |
DROP CONSTRAINT constraint_name
|
...