Teradata语法学习,
创建一个和表T2结构一样的新表T1,带数据的和不带数据的,格式如下:
create table dw.T1 as dw.T2 with data;
create table dw.T1 as dw.T2 with no data;
查看表结构定义:
show table dw.T1;
CREATE MULTISET TABLE dwmart_amp.IM_USER ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
DEFAULT MERGEBLOCKRATIO
(
USR_ID VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
USR_PWD VARCHAR(256) CHARACTER SET LATIN NOT CASESPECIFIC TITLE '登录密码' NOT NULL,
USR_NAME VARCHAR(64) CHARACTER SET LATIN NOT CASESPECIFIC TITLE '用户名' NOT NULL,
USR_ATTR VARCHAR(4000) CHARACTER SET LATIN NOT CASESPECIFIC TITLE '用户属性')
UNIQUE PRIMARY INDEX PK_CS_LOG ( USR_ID );
insert into dwmart_AMP.IM_USER(USR_ID,USR_PWD,USR_NAME,USR_ATTR) VALUES('admin','111111','admin','something');
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。