mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-05-11 13:21:30 +03:00
13 lines
340 B
SQL
13 lines
340 B
SQL
-- Create table with schema, table option and primary key as column constraint
|
|
CREATE TABLE calpont.PART_956
|
|
(p_17c char(12) default '3',
|
|
p_29 numeric(5,2) primary key,
|
|
p_30 double default 3.14159,
|
|
p_31 double precision default 123.456,
|
|
p_32 date,
|
|
p_33 blob,
|
|
p_34 clob,
|
|
p_35 number,
|
|
check(fooby),
|
|
check(dooby))
|