개발은 핵찜이야/DATABASE
[MSSQL] 제약삭제후 속성 수정
주인정
2012. 4. 17. 10:21
USE [db]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[제약명]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[테이블] DROP CONSTRAINT [제약명]
END
GO
ALTER TABLE [dbo].[테이블] ALTER COLUMN Appstate VARCHAR(20)
USE [db]
GO
ALTER TABLE [dbo].[테이블] ADD CONSTRAINT [제약명] DEFAULT ('D') FOR [AppState]
GO