1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-06-10 17:41:44 +03:00
Files
mariadb-columnstore-engine/dbcon/ddlpackage/sql/atmcsd01.sql
2016-01-06 14:08:59 -06:00

9 lines
360 B
SQL

-- set default
alter table tbl_name alter col_name set default 3;
alter table tbl_name alter col_name set default USER;
alter table tbl_name alter col_name set default CURRENT_USER;
alter table tbl_name alter col_name set default SESSION_USER;
alter table tbl_name alter col_name set default SYSTEM_USER;
alter table tbl_name alter col_name set default NULL;