我创建了一个表,但是ponum 定义的长度太短,想给他改长点,用以以下语句,可一直提示错误
ALTER TABLE purchase_order4 ALTER COLUMN ponum CHARACTER(10);
CREATE TABLE purchase_order4
(
ponum character(5) NOT NULL,
qty character(10),
orderdate date,
duedate date,
receiveddate date,
CONSTRAINT purchase_order4_pkey PRIMARY KEY (ponum)
)
------解决方案--------------------
--查询约束
sp_helpconstraint purchase_order4
--删除约束
ALTER TABLE purchase_order4
drop constraint purchase_order4_pkey
然后你再修改下字段试试..
------解决方案--------------------
ALTER TABLE purchase_order4 add constraint purchase_order4_pkey PRIMARY KEY(ponum)
还有别忘了再加回约束..
------解决方案--------------------
CREATE TABLE purchase_order4
(
ponum character(5) NOT NULL,
qty character(10),
orderdate datetime,
duedate datetime,
receiveddate datetime,
CONSTRAINT purchase_order4_pkey PRIMARY KEY (ponum)
)
--改变前字符长度为5
/*
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------- -------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------