Monday 11 April 2011

DDL : Alter a column

Note - for some table modifications, you'll need to set option 'select into' ON

-- modify a column

alter table invoice_detail modify
inv_type varchar(50) not null
go

-- modify multiple columns

alter table invoice_detail modify
inv_type varchar(50) not null,
inv_priority varchar(50) null,
inv_strategic varchar(50) null,
inv_total money null
go

No comments:

Post a Comment