SQL 新增/修改表字段列的类型等

例如:
修改(列名前要有column关键字)
ALTER TABLE [USER] ALTER column [NAME] varchar(35) null
新增
ALTER TABLE [USER] ADD [PRICE]     numeric(18, 8) NULL  DEFAULT 0

通过更改、添加、除去列和约束，或者通过启用或禁用约束和触发器来更改表的定义。

语法
ALTER TABLE table
{ [ ALTER COLUMN column_name
    { new_data_type [ ( precision [ , scale ] ) ]
        [ COLLATE < collation_name > ]
        [ NULL | NOT NULL ]
        | {ADD | DROP } ROWGUIDCOL }
    ]
    | ADD
        { [ < column_definition > ]
        | column_name AS computed_column_expression
        } [ ,...n ]
    | [ WITH CHECK | WITH NOCHECK ] ADD
        { < table_constraint > } [ ,...n ]
    | DROP
        { [ CONSTRAINT ] constraint_name
            | COLUMN column } [ ,...n ]
    | { CHECK | NOCHECK } CONSTRAINT
        { ALL | constraint_name [ ,...n ] }
    | { ENABLE | DISABLE } TRIGGER
        { ALL | trigger_name [ ,...n ] }
}

< column_definition > ::=
    { column_name data_type }
    [ [ DEFAULT constant_expression ] [ WITH VALUES ]
    | [ IDENTITY [ ( seed , increment ) [ NOT FOR REPLICATION ] ] ]
        ]
    [ ROWGUIDCOL ]
    [ COLLATE < collation_name > ]
    [ < column_constraint > ] [ ...n ]

< column_constraint > ::=
    [ CONSTRAINT constraint_name ]
    { [ NULL | NOT NULL ]
        | [ { PRIMARY KEY | UNIQUE }
            [ CLUSTERED | NONCLUSTERED ]
            [ WITH FILLFACTOR = fillfactor ]
            [ ON { filegroup | DEFAULT } ]
            ]
        | [ [ FOREIGN KEY ]
            REFERENCES ref_table [ ( ref_column ) ]
            [ ON DELETE { CASCADE | NO ACTION } ]
            [ ON UPDATE { CASCADE | NO ACTION } ]
            [ NOT FOR REPLICATION ]
            ]
        | CHECK [ NOT FOR REPLICATION ]
            ( logical_expression )
    }

< table_constraint > ::=
    [ CONSTRAINT constraint_name ]
    { [ { PRIMARY KEY | UNIQUE }
        [ CLUSTERED | NONCLUSTERED ]
        { ( column [ ,...n ] ) }
        [ WITH FILLFACTOR = fillfactor ]
        [ ON { filegroup | DEFAULT } ]
&'7DTE4$6$%fU'7FBff6'7&VfW&VW"f6'7'7FRf6fF&'776ff4$6$TdU$T2fFR6fFBff6'7vFff6&F7V&6RfFBfff7'7FFf2f'7ffBf&W"ffB'7fV'7d$4"bf4$64T4f6f2f'76fRf%f'7R"ffFBff6'7vFffFVfV'7f76fDT424$6VDTdTft2f7fFTtfD$fFTt#fk{XX[~iNXzyNXr#K{XXzyN8X[~ifDTdTfZyNX~nKyJftDfdU2fKKNYNxX.Zh.i*iKyJftDfdU>>KjNikX~K;nX[~ifX"##DU"fD$fF&fDBfFDFFRf6FFWFf$FDFFTFfDTdTfvWFFFRftDfdU2#fzhyJ[nxkY K{ni#KhyJyJKXnXXjkNi[hyN{ni8%tDfT4f4$K'7U"fD$fK[~KyJ^zhyJi[nKj[h8^Xk^KK[[~{niyNhi8[^h~%tDf4T4f4$xkY ^{ni8"##TDRfD$f6fBfffRfd$4"fff6'ffffff4$6'f4T4f6'fffffBf'G4%Bff6fdU2f'7'&S%Bff6fdU2f"'f6F"SfF2f'BffW2fFRf6&%Bff6fdU2f2Bf"SfF6&fFRf6&G'fvU"fD$f6fT4f4$6'%Bff6fdU2f2Bf"Sf&VVfFRf6&G'fW"f'BvffU"fD$f6f4T4f4$6'%Bff6fdU2fBW&2f2"#fzhyJ[nxkY nX#KyJfU"fD$fyBfD4$fE$ttU"fizhyJznX^Kj[h8^Xk^KKznXiKnyNhi8[^h~.xKnYKyJfTfE$ttU"fxkY nX8"##TDRfD$fG&ufBffRfd$4"'fv7&VFRfFRfG&vvW"TDRfE$ttU"fG&sf'7G&ufd'7%F2fbf4T5Bf4fe$'7%DTEtU$Rf6'ffwCfffwCf$Tt%E$sfW'&'7GFVFVBfF7'Bff6'ffwCfC%$4fE$5DDtGFVBf'7'BfFBffW2fFRfG&vvW"4U%BffG&ufdU2fBf6F"tF6&fFRfG&vvW"DU"fD$fG&ufD4$fE$ttU"fG&stGFVBf'7'BfFBfvfffRfFRfG&vvW$%BffG&ufdU2f"6V6f"t&RfFRfG&vvW"DU"fD$fG&ufTfE$ttU"fG&stGFVBf'7'BfFBffW2fFRfG&vvW"4U%BffG&ufdU2f2'f&"t#

SQL 新增/修改 表字段列的类型等

SQL 新增/修改表字段列的类型等