开发者

Query for altering the columns default value

I have googled a lot with no success , just need to know the query for altering the column defau开发者_如何学JAVAlt value.


1) Drop the old default value:

ALTER TABLE <TableName> DROP CONSTRAINT <DF_ContstraintName>

2) Add new default value:

ALTER TABLE <TableName> ADD CONSTRAINT
<DF_ContstraintName> DEFAULT <Value> FOR <ColumnName>
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜