SQLServer2000如何判断表是否存在 SQLServer2000如何在程序中用代码判断表是否存在,望大侠多指点! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 if exists(select 1 from sysobjects where name = 'tablename') print 'yes'else print 'no' mysql中创建不存在的表是用if not exists,不知道sqlserver中用什么可以代替它的功能! if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) print 'yes'else print 'no' 不好意思,刚刚吃饭去了,我在网上也查到了这句代码,但我不知道where 后面是什么意思——N'[dbo].[表名]'、N'IsUserTable'代表的是什么啊? 具体的,你可以查一下帮助。OBJECT_ID返回数据库对象标识号。语法OBJECT_ID ( 'object' )OBJECTPROPERTY返回当前数据库中对象的有关信息。语法OBJECTPROPERTY ( id , property ) OBJECT_ID('object')的参数好象是表名,但OBJECTPROPERTY(id,property)里面的'property'不知道是什么! 在SQLServer2000中如何用sql语句代替MySQL中的if not exists,创建不存在的表! 看一下系统pubs表的脚本代码就明白了。if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__titleauth__au_id__0519C6AF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AFGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[authors]GOCREATE TABLE [dbo].[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 , [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 ) ON [PRIMARY]GO if exists语句中,object_id()和OBJECTPROPERTY()里面的参数是什么啊?还有,如果存在的话也不要drop这个表 其实最简单的是这样:use yourdb;goif object_id(N'tablename','U') is not nullprint '存在'else print '不存在' use yourdb;goif object_id(N'tablename',N'U') is not nullprint '存在'else print '不存在' USE [实例名]GOIF EXISTS (SELECT * FROM dbo.SysObjects WHERE ID = object_id(N'[表名]') AND OBJECTPROPERTY(ID, 'IsTable') = 1)PRINT '存在'ELSEPRINT'不存在' 仅仅判断是否存在不行啊if object_id(N'tablename',N'U') is not nullprint '存在'else print '不存在'这语句也只能在查询分析器中运行,我要在程序中动态判断并创建! use tempdbgo if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)CREATE TABLE [dbo].[authors] ( [au_id] [int] 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 , [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 ) ON [PRIMARY]go 如果不存在就建立,否则什么都不做,上面代码是可以的创建authors表 这个SQL语句怎么写? 遇到被零除错误 安装sql2005的问题 高分,立即结贴 如何选择有2项相同的纪录 以前肯定有人问过,,CSDN的后台数据库是什么?? 如何判断一个字段的内容在另一个字段中是否出现过,请求帮忙! VB sql分数段及相关问题 sql查询excel数据语句? 在线等待,急!!!在oracle中的utl_file有关的命令在sqlserver2000中相关的命令是什么? 如何查询SQL表的创建人 新手上路:两个简单的sql语句问题: 请教怎样取出一段字符串中最大的那个日期时间?
print 'yes'
else
print 'no'
print 'yes'
else
print 'no'
返回数据库对象标识号。语法
OBJECT_ID ( 'object' )OBJECTPROPERTY
返回当前数据库中对象的有关信息。语法
OBJECTPROPERTY ( id , property )
ALTER TABLE [dbo].[titleauthor] DROP CONSTRAINT FK__titleauth__au_id__0519C6AF
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[authors]
GOCREATE TABLE [dbo].[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 ,
[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
) ON [PRIMARY]
GO
还有,如果存在的话也不要drop这个表
goif object_id(N'tablename','U') is not null
print '存在'
else
print '不存在'
use yourdb;
goif object_id(N'tablename',N'U') is not null
print '存在'
else
print '不存在'
GOIF EXISTS (SELECT * FROM dbo.SysObjects WHERE ID = object_id(N'[表名]') AND OBJECTPROPERTY(ID, 'IsTable') = 1)
PRINT '存在'
ELSE
PRINT'不存在'
if object_id(N'tablename',N'U') is not null
print '存在'
else
print '不存在'
这语句也只能在查询分析器中运行,我要在程序中动态判断并创建!
use tempdb
go
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)CREATE TABLE [dbo].[authors] (
[au_id] [int] 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 ,
[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
) ON [PRIMARY]go
创建authors表