数据仓库服务 GAUSSDB(DWS)-CREATE FOREIGN TABLE (SQL on other GaussDB(DWS)):语法格式

时间:2024-04-18 16:25:02

语法格式

1
2
3
4
5
6
7
CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name
( [ { column_name type_name | LIKE source_table } [, ...] ] )
SERVER server_name
OPTIONS ( { option_name ' value ' } [, ...] )
[ READ ONLY ]
[ DISTRIBUTE BY {ROUNDROBIN} ]
[ TO { GROUP groupname | NODE ( nodename [, ... ] ) } ];
support.huaweicloud.com/sqlreference-830-dws/dws_06_0162.html