|
Home > Archive > SQL Anywhere Mobile > May 2005 > Error when altering table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error when altering table
|
|
| Chance 2005-05-17, 9:23 am |
| Hello,
I am trying to alter a table in our database. However, I am receiving the
error "table x is part of a synchronization defintion. This confuses me
though because I have this code prior to doing any alteration.
DROP SYNCHRONIZATION SUBSCRIPTION TO Booklog " + "FOR " + ls_SiteID
Another question, how can you tell if a subscription exists or not?
tia,
chance.
| |
| Breck Carter [TeamSybase] 2005-05-17, 9:23 am |
| You cannot alter a table that is part of a publication (e.g., CREATE
PUBLICATION).
SELECT SYSTABLE.table_name,
SYSPUBLICATION.publication_name
FROM SYSTABLE
INNER JOIN SYSARTICLE
ON SYSTABLE.table_id
= SYSARTICLE.table_id
INNER JOIN SYSPUBLICATION
ON SYSARTICLE.publication_id
= SYSPUBLICATION.publication_id;
On 17 May 2005 06:52:33 -0700, "Chance" <chance@booklog.com> wrote:
>Hello,
>I am trying to alter a table in our database. However, I am receiving the
>error "table x is part of a synchronization defintion. This confuses me
>though because I have this code prior to doing any alteration.
>
>DROP SYNCHRONIZATION SUBSCRIPTION TO Booklog " + "FOR " + ls_SiteID
>
>Another question, how can you tell if a subscription exists or not?
>
>tia,
>chance.
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Chance 2005-05-17, 9:23 am |
| Can I not drop and re-add it?
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:90uj811smur2ctu
sng3pbcdab7a2npkhtk@
4ax.com...
> You cannot alter a table that is part of a publication (e.g., CREATE
> PUBLICATION).
>
> SELECT SYSTABLE.table_name,
> SYSPUBLICATION.publication_name
> FROM SYSTABLE
> INNER JOIN SYSARTICLE
> ON SYSTABLE.table_id
> = SYSARTICLE.table_id
> INNER JOIN SYSPUBLICATION
> ON SYSARTICLE.publication_id
> = SYSPUBLICATION.publication_id;
>
> On 17 May 2005 06:52:33 -0700, "Chance" <chance@booklog.com> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Greg Fenton 2005-05-17, 1:24 pm |
| Chance wrote:[color=darkred
]
> Can I not drop and re-add it?
>
> "Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
> message news:90uj811smur2ctu
sng3pbcdab7a2npkhtk@
4ax.com...
>
You cannot DROP TABLE or ALTER TABLE if it is in a publication. You
need to remove it from the publication (ALTER PUBLICATION DROP TABLE
....), then drop/alter it.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|
|