On Tue, Jul 8, 2008 at 3:32 PM, Ailsom F. Heringer (OSKLEN)
<[EMAIL PROTECTED]> wrote:
> Foxers,
>
> I am trying to drop a column at SQLSERVER table. The data type of this
> column is BIT with a default value as object called DEFAULT_0.
>
>
>
> When I send :
>
> ALTER TABLE CLIENTES_VAREJO DROP COLUMN HEAR_ABOUT_FRIEND
>
>
>
> I get the following message error:
>
> The object 'DEFAULT_0' is dependent on column 'HEAR_ABOUT_FRIEND'.
>
---------------------------------------------------------------
You need to remove the RULE for a default value first:
ALTER TABLE dbo.CLIENTES_VAREJO
DROP CONSTRAINT 'DEFAULT_0
GO
then your drop column will be fine. You can't just drop the column if
another object is dependent on it's PRESENCE.
--
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN
901.246-0159
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
