Drop a column

[SonJ]

hi,

does anyone know of a sql command which lets you drop a column in table? so far, i have been unsuccessful in finding a one-liner command that lets me do this.

thanks in advance,
SonD

 

[swampBoogie]

alter table t drop column c restrict
-- or
alter table t drop column c cascade

is the ANSI SQL syntax.

There may be local variations, e.g. no support for restrict or cascade.

Some may also not recognize the keyword column. So check the documentation for your DBMS.