改变表的一列的缺省值

sql server :

ALTER TABLE dbo.Test ADD CONSTRAINT
DF_Test_column2 DEFAULT 'a' FOR column2


oracle:

ALTER TABLE "BV1TO1"."DT_CONTEST_SUPP" MODIFY("ACCEPT" DEFAULT 1)

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus