dbTalk Databases Forums  

Wierd error preventing Drop column

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Wierd error preventing Drop column in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve
 
Posts: n/a

Default Wierd error preventing Drop column - 09-01-2010 , 05:50 PM






Hi, I'm getting a strange error trying to drop a column. Has anybody
seen this before?
I dropped the primary key, all indexes, foreign keys, constraints from
the table.

The column 'diaedu_diabetes' could not be deleted from the database.
Primary key for row in table 'ISYSTABCOL' is referenced by foreign key
'ISYSTABCOL' in table 'ISYSARTICLECOL'
[Sybase][ODBC Driver][SQL Anywhere]Primary key for row in table
'ISYSTABCOL' is referenced by foreign key 'ISYSTABCOL' in table
'ISYSARTICLECOL'
SQLCODE: -198
SQLSTATE: 23000
SQL Statement: ALTER TABLE
"app_owner"."diaedu_diabetes_education_assessment" DROP
"diaedu_diabetes"

Any help appreciated

thanks,
Steve

Reply With Quote
  #2  
Old   
Steve
 
Posts: n/a

Default Re: Wierd error preventing Drop column - 09-01-2010 , 05:52 PM






On Sep 1, 3:50*pm, Steve <ssag... (AT) gmail (DOT) com> wrote:
Quote:
Hi, *I'm getting a strange error trying to drop a column. *Has anybody
seen this before?
Forgot to include, I'm running SQL Anywhere Personal Server Version
11.0.1.2436

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.