Search:

I want to drop columns from a table using alter table.

I have used alter table drop column

This gives me syntax error.

Can anyone please let me know how to add / drop columns to table in...

Lets say you want to create trigger on table1 having columns id and name.

The syntax would be

create trigger insert on my_table as
begin
insert into my_table values (0,"new NAME inserted")...