#10340: Delete column from table window,it give error message.

kirtipbankar(*) reported 2013-10-07T10:55:31Z · last modified 2013-10-09T19:23:37Z

Delete column from table window,it give error message.

Dev	kirtipbankar(*)
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	14.0

Database version: Sybase ASE 15.7

ADS version : ADS-windows-x64-14.0-rc-44

Connect Sybase ASE

Create Database:-

CREATE DATABASE kirti

ON master = '22624K'

Create following table(User Tables):-

CREATE TABLE dbo.test_3 (

col1 int NULL,

col2 text NULL,

col3 varchar(25) NULL

)

Go to table node ->Right click on these table

Select table tree node and Right click on this table-> Select Alter table->

Right click on column-> Select Delete column option->delete column->click on alter button.->It give error message ""

Now you will observe that,when we delete column from table window its give error message.

3 attachments

1.jpg

2013-10-07T10:58:09Z

325 KB
3.jpg

2013-10-08T12:35:44Z

373 KB
2.jpg

2013-10-08T12:39:40Z

249 KB

All Comments (4) Change History

tariqrahiman 2013-10-07T18:05:15Z

I was not able to reproduce. Can you try in a different database, Alter in different table and check if this is reproducible. Also, please verify the error message that is returned from the Server which says Alter Table with datacopy cannot be done. Please fix the error and try again.

kirtipbankar(*) 2013-10-08T12:35:02Z

I have checked Sybase ASE documentation.In sybase ASE the query to delete particular column is

AlTER TABLE test_4

drop col3

with no datacopy

This query executed successfully on query analyser window in ADS.Instead of default query given in ads.I also checked same think in ADS-14-dev-33 this issue reproducible in this version also.

I am providing link and screenshot which i have followed,

http://infocenter.sybase.com/help/index.jsptopic=/com.sybase.infocenter.dc00641.1572/html/new_features/new_features65.htm

tariqrahiman 2013-10-08T17:34:26Z

This is not an error in ADS - the error message is returned from the Sybase ASE Server. With no datacopy is optional. To fix the error message, execute the below query and verify if you are not able to Delete

use kirti

master..sp_dboption kirti, "select into", true

tariqrahiman 2013-10-08T19:18:59Z

I have added an improvement for ADS v15 to improve the Alter Table Drop Column script that gets generated. See issue https://www.aquaclusters.com/app/home/project/public/aquadatastudio/issue/10366

Search Tips

Aqua Data Studio / nhilam

Delete column from table window,it give error message.

3 attachments

Issue #10340

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Delete column from table window,it give error message.

3 attachments

Issue #10340

Completion