SQL如何增刪修改欄位

1: 新增欄位:

ALTER TABLE [Business].[LandInfo] Add LandFormalitiesSituation NVARCHAR(200)  NULL
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'土地手續辦理情況' , @level0type=N'SCHEMA',@level0name=N'Business', @level1type=N'TABLE',@level1name=N'LandInfo', @level2type=N'COLUMN',@level2name=N'LandFormalitiesSituation'

2:刪除欄位:

ALTER TABLE [Business].ProjectInfo DROP COLUMN ConstructionSituation

3:修改欄位名:

EXEC sp_rename 'Business.ProjectImageInfo.ProjectInfoCode','ResourceID','COLUMN'

4:修改欄位類型:

ALTER TABLE Business.LandNature ALTER COLUMN Creator NVARCHAR(64)