Custom Search
www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript


Technical Guides
Sybase
Oracle
UNIX
Javascript




Of Interest

Business Intelligence and Analytics



Oracle Training

Sybase » DDL » Design » alter column

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





Sybase : Related Topics

Sybase : DDL : Sybase data types
Sybase : DDL : Creating a table
Sybase : DDL : Altering a table
Sybase : DDL : Creating an index
Sybase : DDL : Clustered vs non-clustered indexes
Sybase : DDL : Creating a constraint
Sybase : DDL : Table Partitioning
Sybase : DDL : Modifying a Colunm

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site



Get the latest Rocket99 news and tech tips via






Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site




Copyright © 2016 Stoltenbar Inc All Rights Reserved.