INFORMIX SQL培训.docVIP

INFORMIX_SQL 语法及函数 SQL(StructuredQueryLanguage)命令培训 |-DML(Data Manipulation Language commands)数据操纵语言 |-DDL(Data Definition Language commands)数据定义语言 SQL--|-TCC(Transaction Control commands)事务控制语言 |-SCC(System Control commands)系统控制语言 1、Alter(变更) Alter tabletabnameadd[colname1type[default value today ,current,] [column constraint] before column.. ALTER TABLE items ADD (item_weight DECIMAL(6,2) DEFAULT 2.0 NOT NULL BEFORE total_price) alter table tabname drop colname1,colname2,.. Alter tabletabnameModify[colname1类型[Null|Not null]]...column constraint disabled,enabled Alter table add constraint (