The object 'DF_xxx_xxx_xxx' is dependant on column 'xxx'.

09 Sep 2010

Support Center » Knowledgebase » The object 'DF_xxx_xxx_xxx' is dependant on column 'xxx'.

	The object 'DF_xxx_xxx_xxx' is dependant on column 'xxx'.

Solution This problem is caused by previous upgrades, if you are installing the latest version of a Symbiant application you should not be encountering it. However if you are installing an older version for some reason you will need to manually remove the constraints before upgrading.

The easiest way to do this is by running the following script against the Symbiant application database through SQL Server Management Studio:



DECLARE @tableName varchar(500), @name varchar(500)

DECLARE cur cursor

FOR SELECT object_name(parent_obj), [name]

FROM dbo.sysobjects

WHERE xtype = 'D'



OPEN cur

FETCH next FROM cur INTO @tableName, @name

WHILE @@fetch_status = 0

BEGIN

EXEC('ALTER TABLE ' + @tableName + ' DROP CONSTRAINT ' + @name)

FETCH next FROM cur INTO @tableName, @name

END

CLOSE cur

DEALLOCATE cur

An alternative is to expand the Symbiant application database to display the tables, then expand each table in turn and delete any DF_ constraints that appear under the constraints node (folder).

Article Details

Article ID:

Created On:

13 Feb 2008 10:55 AM

Login

[Lost Password]

Search

Article Options