sybase数据库删除一列的语法是什么？

[sunyo]

在SQL SERVER中可以用：
alter table info drop column bt

可是在SYBASE中却提示：
Server Message: Number 102, Severity 15
Line 1:
Incorrect syntax near 'bt'.

请问正确的语法是什么？
先谢谢了！

[hobbylu]

详细语法可以参考书册

[gawz]

try this:
alter table info delete column bt

[lw1a2]

alter table info drop bt

[gawz]

ALTER TABLE [ owner.]table-name
{ add-clause | modify-clause | drop-clause | rename-clause }
drop-clause :
{ DELETE | DROP }{
column-name
...

[爱猫的鱼V]

ALTER TABLE employee
DELETE office

(即:alter table 表名 delete 字段名 )

[yxlpf]

sa登录连到master
delete from sysdatabases where name='xxxxx'
go
delete from sysusages where dbid not in (select dbid from sysdatabases)
go
DBCC CHECKALLOC
go
删除devices
delete from sysdevices where name='xxx'
go
DBCC CHECKALLOC
go

xxxx 皆为数据库名称
xxx 皆为设备名称，不是文件名