if exists (select*from sysobjects
where id=object_id(N'[dbo].[password]')
and OBJECTPROPERTY(id,N'IsUserTable')=1)
drop table[dbo].[password]CREATE TABLE [dbo].[password](
[id] [char] (10) NULL,
[password] [char] (10) NULL,
[name] [char](20) NULL,
[email] [char] (30) NULL,
[txdz] [char] (50) NULL,
) ON [PRIMARY]
go
where id=object_id(N'[dbo].[password]')
and OBJECTPROPERTY(id,N'IsUserTable')=1)
drop table[dbo].[password]CREATE TABLE [dbo].[password](
[id] [char] (10) NULL,
[password] [char] (10) NULL,
[name] [char](20) NULL,
[email] [char] (30) NULL,
[txdz] [char] (50) NULL,
) ON [PRIMARY]
go
where id=object_id(N'[dbo].[password]')
and OBJECTPROPERTY(id,N'IsUserTable')=1)
drop table[dbo].[password]
exec('
CREATE TABLE [dbo].[password](
[id] [char] (10) NULL,
[password] [char] (10) NULL,
[name] [char](20) NULL,
[email] [char] (30) NULL,
[txdz] [char] (50) NULL,
) ON [PRIMARY]
')
第二个正确。谢谢!
为什么可以告诉我么?QQ:95252968