-
Junior Member
Add drop columns in Sybase ASE 15.0
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 ASE 15.0
-
Junior Member
Re: Add drop columns in Sybase ASE 15.0
Hi,
The Syntax remains the same to add or drop a column.
Alter table add/drop column
we cannot drop a computed column.
Thanks
-
Junior Member
Re: Add drop columns in Sybase ASE 15.0
alter table table_name
drop column_name
go
sp_recompile table_name
go
Last edited by knagaokar; 12-02-2008 at 01:06 PM.
Reason: within <> not going in
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules