컬럼 변경

============================================================

CREATE TABLE [dbo].[Table_1](
 [col1] [varchar](50) COLLATE Korean_Wansung_CI_AS NULL,
 [col2] [varchar](50) COLLATE Korean_Wansung_CI_AS NULL,
 [col3] [varchar](32) COLLATE Korean_Wansung_CI_AS NULL,
) ON [PRIMARY]

============================================================

[컬럼 추가]

ALTER TABLE [dbo].[Table_1] ADD [col4] [varchar](50) COLLATE Korean_Wansung_CI_AS NULL;

 

[컬럼 제거]

ALTER TABLE [dbo].[Table_1] DROP COLUMN [col4];

 

[컬럼명 변경]

sp_rename 'Table_1.col1','col1_bak';

 

[사이즈 변경]

ALTER TABLE [dbo].[Table_1] ALTER COLUMN [col1] [varchar](min);

ALTER TABLE [dbo].[Table_1] ALTER COLUMN [col1] [varchar](32);

ALTER TABLE [dbo].[Table_1] ALTER COLUMN [col1] [varchar](64);

ALTER TABLE [dbo].[Table_1] ALTER COLUMN [col1] [varchar](max);

 

[타입 변경]

ALTER TABLE [dbo].[Table_1] ALTER COLUMN [col1] [nvarchar](min);

ALTER TABLE [dbo].[Table_1] ALTER COLUMN [col1] [nvarchar](32);

ALTER TABLE [dbo].[Table_1] ALTER COLUMN [col1] [nvarchar](64);

ALTER TABLE [dbo].[Table_1] ALTER COLUMN [col1] [nvarchar](max);