ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[d_mtrd]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[d_mtrd]
GO
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[d_mtrin]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[d_m
代码一般,可以供初学者学习