Alter Table on a Sybase ASE table fails after trying to change the column length (4303556)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Alter Table on a Sybase ASE table fails after trying to change the column length
Description

Alter Table on a Sybase ASE table fails after trying to change the column length.

"Sybase Database Error:
Warning: no columns to drop, add or modify. ALTER TABLE 'schema.tablename' was aborted."

Toad does not change the column length in the script.

use TEST_new
go
-- Modify
alter table TEST_new.dbo.a_sk_test1 modify
col1
go
Resolution

This issue no longer occurs in version 3.4. The latest version of Toad can be downloaded from the Support Portal

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title