sql server 的写法
declare @tableName nvarchar
SELECT @tableName='newTable'
if not EXISTS (
SELECT * from sysobjects
where id = object_id(@tableName) --查询表是否存在
and (OBJECTPROPERTY(id, 'IsUserTable') = 1)) --判断表是否为用户自定义
create table newTable (
id int,
name nvarchar(10),
age int,
sex nvarchar(10)
)
GO