You can drop any table if the table:
Is not being used as an article in a publication.
Does not have any columns that are referenced by another table's foreign key.
In these cases, you must change the publication or delete the foreign key before you can successfully delete the table.
You can use either Sybase Central or Interactive SQL to perform this task.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|