Alter table drop column Error

[Alex]

1. We have user defined type (Sql type = bit ) with rule setting it to 0
2. New column(isVIP) was created using this user defined type
3. sp_unbindrule was used to unbind rule from new column (isVIP)
4. Alter table Client drop Column isVIP !!!! (invalid syntax )

Any ideas ?
Thanks

[MAK]

Try this...

create table MAK (id char(10), name int, isVIP bit)
insert into MAK select "x",1,0
insert into MAK select "x",2,0
insert into MAK select "x",3,1
insert into MAK select "x",4,0
insert into MAK select "x",5,1

select * from MAK
alter table MAK drop column [isVIP]



-MAK
------------
Alex at 4/11/01 9:03:35 AM

1. We have user defined type (Sql type = bit ) with rule setting it to 0
2. New column(isVIP) was created using this user defined type
3. sp_unbindrule was used to unbind rule from new column (isVIP)
4. Alter table Client drop Column isVIP !!!! (invalid syntax )

Any ideas ?
Thanks

[Alex]

create , insrert fine then

trying .....
alter table MAK drop column [isVIP]

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'isVIP'.



------------
MAK at 4/11/01 10:15:07 AM

Try this...

create table MAK (id char(10), name int, isVIP bit)
insert into MAK select "x",1,0
insert into MAK select "x",2,0
insert into MAK select "x",3,1
insert into MAK select "x",4,0
insert into MAK select "x",5,1

select * from MAK
alter table MAK drop column [isVIP]



-MAK
------------
Alex at 4/11/01 9:03:35 AM

1. We have user defined type (Sql type = bit ) with rule setting it to 0
2. New column(isVIP) was created using this user defined type
3. sp_unbindrule was used to unbind rule from new column (isVIP)
4. Alter table Client drop Column isVIP !!!! (invalid syntax )

Any ideas ?
Thanks

[hiku]

Just a suggestion...Check db compatibility...if it is 65 alter command would not work....

------------
Alex at 4/11/01 9:03:35 AM

1. We have user defined type (Sql type = bit ) with rule setting it to 0
2. New column(isVIP) was created using this user defined type
3. sp_unbindrule was used to unbind rule from new column (isVIP)
4. Alter table Client drop Column isVIP !!!! (invalid syntax )

Any ideas ?
Thanks

it is SQL version 7.00.842


------------
hiku at 4/11/01 1:44:31 PM


Just a suggestion...Check db compatibility...if it is 65 alter command would not work....

------------
Alex at 4/11/01 9:03:35 AM

1. We have user defined type (Sql type = bit ) with rule setting it to 0
2. New column(isVIP) was created using this user defined type
3. sp_unbindrule was used to unbind rule from new column (isVIP)
4. Alter table Client drop Column isVIP !!!! (invalid syntax )

Any ideas ?
Thanks