怎样删除一个表呢？用什么语句？

[youngby]

表如下：
create Table dbo.EmployeeMgrExamployee1
(
EmpID int identity(1,1) not null primary key clustered,
SSN char(10) not null unique nonclustered,
LastName varchar(20) not null,
FirstName varchar(20) not null,
Gender char(1) null,
JobTitle varchar(20) null
,
MgrId int Not null
references dbo.EmployeeMgrExamployee1(EmpID))

[youngby]

declare @myPk sysname
declare @myfk sysname
select @myPk=c.name from syscolumns a,sysconstraints b,sysobjects c
where a.id=object_id('EmployeeMgrExamployee1') and a.name='EmpID' and
a.id=b.id and b.constid=c.id and c.name like 'PK%'

select @myFk=c.name from syscolumns a,sysconstraints b,sysobjects c
where a.id=object_id('EmployeeMgrExamployee1') and a.name='MgrId' and
a.id=b.id and b.constid=c.id and c.name like 'fK%'

if @myPk is not null and @myPk<> ''
begin
alter table EmployeeMgrExamployee1
drop constraint @myPk
end
if @myPk is not null and @myPk<> ''
begin
alter table EmployeeMgrExamployee1
drop constraint @myFk
end
drop table EmployeeMgrExamployee1


有错误，，请问如何改正？？

55555
没有分了。
请帮忙。

[lynx1111]

try:
declare @myPk sysname
declare @myfk sysname
declare @str1 varchar(200)
declare @str2 varchar(200)
select @myPk=c.name from syscolumns a,sysconstraints b,sysobjects c
where a.id=object_id('EmployeeMgrExamployee1') and a.name='EmpID' and
a.id=b.id and b.constid=c.id and c.name like 'PK%'

select @myFk=c.name from syscolumns a,sysconstraints b,sysobjects c
where a.id=object_id('EmployeeMgrExamployee1') and a.name='MgrId' and
a.id=b.id and b.constid=c.id and c.name like 'fK%'

if @myPk is not null and @myPk<> ''
begin
set @str1='alter table EmployeeMgrExamployee1 drop constraint'+ @myPk
exec (@str1)
end
if @myPk is not null and @myPk<> ''
begin
set @str2='alter table EmployeeMgrExamployee1 drop constraint'+ @myFk
exec (@str2)
end
drop table EmployeeMgrExamployee1

[shuiniu]

declare @myPk sysname
declare @myfk sysname
select @myPk=c.name from syscolumns a,sysconstraints b,sysobjects c
where a.id=object_id('EmployeeMgrExamployee1') and a.name='EmpID' and
a.id=b.id and b.constid=c.id and c.name like 'PK%'

select @myFk=c.name from syscolumns a,sysconstraints b,sysobjects c
where a.id=object_id('EmployeeMgrExamployee1') and a.name='MgrId' and
a.id=b.id and b.constid=c.id and c.name like 'fK%'

if @myFk is not null and @myFk<> ''
begin
exec('alter table EmployeeMgrExamployee1
drop constraint ' +@myFk)
end
if @myPk is not null and @myPk<> ''
begin
exec('alter table EmployeeMgrExamployee1
drop constraint ' + @myPk )
end
drop table EmployeeMgrExamployee1

[shuiniu]

要先删FK再删PK!!!

[pengdali]

drop table EmployeeMgrExamployee1


就可以了