Posted by Tibor Karaszi on 09/20/05 17:56

ALTER TABLE tblname DROP CONSTRAINT constraintname

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/


"Steve" <steve@hello.com> wrote in message news:43301ef3_1@x-privat.org...
> How do I delete a relationship between tables in SQL Server 7.0?
>
> I previously had a relationship between two tables, but I renamed the field
> and table of one of the tables and the old relationship still points to the
> old field name and table. How do I remove the defunct relationship?
>
> It doesn't show in my diagram because the old table no longer exists (well
> it does but it's been renamed).
>
>

[Back to original message]