MSSqlBuilder can't drop a table with constraints with names longer than 60
characters
-------------------------------------------------------------------------------------
Key: DDLUTILS-109
URL: http://issues.apache.org/jira/browse/DDLUTILS-109
Project: DdlUtils
Type: Bug
Reporter: Christoffer Hammarström
Assigned to: Thomas Dudziak
I get this error because the constraint name has been truncated to 60
characters (These are the same foreign keys i had trouble with in DDLUTILS-106,
but on existing databases):
'new_doc_permission_sets_ex_FK_meta_id_set_id_new_doc_permiss' is not a
constraint. Query: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND
name = 'Tmp_new_doc_permission_sets')
BEGIN
DECLARE @reftable nvarchar(60), @constraintname nvarchar(60)
DECLARE refcursor CURSOR FOR
select reftables.name tablename, cons.name constraintname
from sysobjects tables,
sysobjects reftables,
sysobjects cons,
sysreferences ref
where tables.id = ref.rkeyid
and cons.id = ref.constid
and reftables.id = ref.fkeyid
and tables.name = 'Tmp_new_doc_permission_sets' OPEN refcursor
FETCH NEXT from refcursor into @reftable, @constraintname
while @@FETCH_STATUS = 0
BEGIN
exec ('alter table '[EMAIL PROTECTED]' drop constraint '[EMAIL
PROTECTED])
FETCH NEXT from refcursor into @reftable, @constraintname
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE Tmp_new_doc_permission_sets
END;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
