不得不问一个很菜的问题!!!

[snowinthewind]

想问一个很菜的问题:
用哪个语句判断所要create的表,在数据库中是否已存在,存在的话,怎么删除?

[dafu71]

-- =============================================
-- Create table basic template
-- =============================================
IF EXISTS(SELECT name
FROM sysobjects
WHERE name = N'<table_name, sysname, test_table>'
AND type = 'U')
DROP TABLE <table_name, sysname, test_table>
GO

CREATE TABLE <table_name, sysname, test_table> (
<column_1, sysname, c1> <datatype_for_column_1, , int> NULL,
<column_2, sysname, c2> <datatype_for_column_2, , int> NOT NULL)
GO

[chao778899]

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[room1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[room1]
GO

CREATE TABLE [dbo].[room1] (
[fu] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[zi] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

[smallroad]

if exists (select * from sysobjects where name = tablename and type = 'U')
Drop table tablename
else
create table

[yun198183]

select * from 表名
存在就会显示
drop table 表名

[愉快的登山者]

if exists (select * from sysobjects where name = yourtablename and type = 'u')
print '有'
else
print '没有'

愉快的登山者

⊙
◢◣◢◣◢◣

[wey1996]

删除用drop table 命令

[zjcxc]

if exists(select 1 from sysobjects where id=object_id('你要测试是否存在的表'))
begin
print '表存在'
drop table 你要测试是否存在的表' --删除表
end
else
print '表不存在'

[hjb111]

if exists (select * from sysobjects where name = yourtablename and type = 'u')
begin
print '有'
drop table yourtablename
end
else
print '没有'

[fmdsaco]

ing

[ysycrazy]

if object_id('表') is not null
drop table 表