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);