Drop a constrain

Hi all,
The table has SP and tables as dependencies
Thanks
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23N7ZVEjjGHA.1640@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I need to delete a table WITH foreign key constrain. What is the fast way
> to drop the table?
> Thanks
>Hi,
I need to delete a table WITH foreign key constrain. What is the fast way to
drop the table?
Thanks|||Hi all,
The table has SP and tables as dependencies
Thanks
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23N7ZVEjjGHA.1640@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I need to delete a table WITH foreign key constrain. What is the fast way
> to drop the table?
> Thanks
>|||On Mon, 12 Jun 2006 11:01:26 -0400, mecn wrote:

>Hi,
>I need to delete a table WITH foreign key constrain. What is the fast way t
o
>drop the table?
ALTER TABLE MyTable
DROP CONSTRAINT MyConstraint;
DROP TABLE MyTable;
Hugo Kornelis, SQL Server MVP|||On Mon, 12 Jun 2006 11:01:26 -0400, mecn wrote:

>Hi,
>I need to delete a table WITH foreign key constrain. What is the fast way t
o
>drop the table?
ALTER TABLE MyTable
DROP CONSTRAINT MyConstraint;
DROP TABLE MyTable;
Hugo Kornelis, SQL Server MVP