问一初级问题，一个表存在就删除，否则就创建？如何写sql

[caoit]

??

[friendliu]

if exists (select * from dbo.sysobjects where id = object_id(N'[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [authors]
else CREATE TABLE [authors] (
[au_id] [id] NOT NULL ,
[au_lname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[au_fname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[phone] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__authors__phone__78B3EFCA] DEFAULT ('UNKNOWN'),
[address] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[city] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[state] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[zip] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[contract] [bit] NOT NULL ,
CONSTRAINT [UPKCL_auidind] PRIMARY KEY CLUSTERED
(
[au_id]
) ON [PRIMARY] ,
CHECK ([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'),
CHECK ([zip] like '[0-9][0-9][0-9][0-9][0-9]')
) ON [PRIMARY]
GO

[friendliu]

假设表为authors

[paoluo]

If Exists (select * from dbo.sysobjects where id = object_id(N'[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Drop Table [表名]