Delete relationship?

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).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).
>|||Referential integrity between tables is implemented using constraints. Try
this:
alter table <table_name> drop constraint <constraint_name
"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).