I can not change column type - Object Depends on the column in question

Question

I can not change column type - Object Depends on the column in question

Navigation

#1 by (1 votes)

1

I need to modify the column type of a client table, however this change will be done through a program written in VB.Net and therefore needs to be done via SQL command.

The issue is that when using the command:

ALTER TABLE Customer ALTER COLUMN COLUNA int;

I get the following message:

The object 'DF__Tmp_Customer__Coluna__15BB0E23' is dependent on column 'Coluna'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE ALTER COLUMN Coluna failed because one or more objects access this column.

I can not apply any changes to the column in question at all ...

sql-server

asked by anonymous 10.10.2014 / 14:00

1 answer

Fix position of a page Update on another line on the same table by Trigger

score 1 · Accepted Answer

Problem Solution:

Script:

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[NomeDaConstraint]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[NomeDaTabela] DROP CONSTRAINT [NomeDaConstraint]
END