SqlServer中 将某个表的某个字段改个默认值

ALTER TABLE [dbo].[表名] ADD CONSTRAINT [DF_表名_列名] DEFAULT ((默认值)) FOR [列名]


ALTER TABLE QA_API ADD CONSTRAINT [DF_QA_API_deletedflag] DEFAULT (0) FOR API_DELETED_FLAG

原文地址:https://www.cnblogs.com/qianjinyan/p/10516588.html