当前位置:Gxlcms > 数据库问题 > SQL Server 约束的增删改

SQL Server 约束的增删改

时间:2021-07-01 10:21:17 帮助过:23人阅读

table orders ( docentry int constraint pk_id primary key not null, --红色部分非空约束 customer_number varchar(20), order_number varchar(20) , order_line int, order_price float )

  (2)修改非空约束

alter table orders 
alter column customer_number varchar(20) not null

alter table orders 
alter column order_number varchar(20) not null

alter table orders 
alter column order_line int not null

SQL Server 约束的增删改

标签:number   custom   char   arc   alt   创建   增删改   lte   ble   

人气教程排行