Thank you very much Gila..

It was my mistake that I used PK_TestTable, but the table, TestTable and the constraint was not existing. When I used an existing table it...

Nothing is getting printed.

For e.g:

DECLARE @val VARCHAR(50)

select @val = name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsConstraint') = 1 AND name like 'PK__TestTable%'

PRINT ('ALTER TABLE [dbo].[VOIP_CUEUsers] DROP CONSTRAINT...

Thanks Gila..

But the above query throws an error:

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'CONSTRAINT'.

Any idea how can I solve it?

Regards

Unnic

Thank you, Frank.

Regards

Unnikrishnan