select * from dbo.sysobjects where id = object_id(N'[dbo].[tableName]') and OBJECTPROPERTY(id, N'IsUserTable') = 1 用表名替换tableName,执行该查询,如果查询结果为空,则表示不存在该表
dbo.sysobjects 是数据库名字么?报错啊
IF Exists(Select * From sysObjects Where Name ='Tbl_Name' And Type In ('S','U')) Print 'Exists Table' Else Print 'Not Exists Table'
select * from sys.objects where [type]='u' and [name]=表名 存在 返回数据表相关信息;不存在 返回空记录集 或select object_id('Cggl_Ylcght') 存在返回 类似 ‘13295157’的object_id值;不存在返回null
能解释下意思么? sysObjects 是什么
IF NOT EXISTS (select * from SysObjects where name='表名') CREATE TABLE 表名
这个不用程序控制。。在SQL里写就行了IF NOT EXISTS (select * from SysObjects where name='表名') CREATE TABLE 表名 ( [x1] [varchar](2), [x2] [varchar](2) ... )
mysql 好像是用 SHOW DATABASES SHOW TABLES 不常用。。记不清楚了
sql server :if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Favorite]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Favorite] GOCREATE TABLE [dbo].[Favorite] ( [FavoriteId] [int] NOT NULL , [FavoriteName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [BookInfoId] [int] NOT NULL , [AssociatorId] [int] NOT NULL , [Del] [tinyint] NOT NULL ) ON [PRIMARY] GO
sql serverif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Favorite]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Favorite] GOCREATE TABLE [dbo].[Favorite] ( [FavoriteId] [int] NOT NULL , [FavoriteName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [BookInfoId] [int] NOT NULL , [AssociatorId] [int] NOT NULL , [Del] [tinyint] NOT NULL ) ON [PRIMARY] GO
1. SHOW TABLES LIKE '%tb_bp_d_case%'; 2. select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA`='dbname' and `TABLE_NAME`='tablename' ; 3. 如果表不存在就建立这个表 create table if not exists tablename http://dev.firnow.com/course/7_databases/mysql/Mysqljs/20090313/161045.htmlMySql用的少,你自己试试
用表名替换tableName,执行该查询,如果查询结果为空,则表示不存在该表
Print 'Exists Table'
Else
Print 'Not Exists Table'
where [type]='u' and [name]=表名
存在 返回数据表相关信息;不存在 返回空记录集
或select object_id('Cggl_Ylcght') 存在返回 类似 ‘13295157’的object_id值;不存在返回null
sysObjects 是什么
CREATE TABLE 表名
如果是sqlserver2005以上的,应该不会有问题。
如果是sqlserver2005一下,略有区别。
如果是Oracle,或者其他的,区别就大了。
CREATE TABLE 表名 (
[x1] [varchar](2),
[x2] [varchar](2)
...
)
SHOW DATABASES
SHOW TABLES 不常用。。记不清楚了
drop table [dbo].[Favorite]
GOCREATE TABLE [dbo].[Favorite] (
[FavoriteId] [int] NOT NULL ,
[FavoriteName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BookInfoId] [int] NOT NULL ,
[AssociatorId] [int] NOT NULL ,
[Del] [tinyint] NOT NULL
) ON [PRIMARY]
GO
drop table [dbo].[Favorite]
GOCREATE TABLE [dbo].[Favorite] (
[FavoriteId] [int] NOT NULL ,
[FavoriteName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BookInfoId] [int] NOT NULL ,
[AssociatorId] [int] NOT NULL ,
[Del] [tinyint] NOT NULL
) ON [PRIMARY]
GO
2. select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA`='dbname' and `TABLE_NAME`='tablename' ;
3. 如果表不存在就建立这个表 create table if not exists tablename http://dev.firnow.com/course/7_databases/mysql/Mysqljs/20090313/161045.htmlMySql用的少,你自己试试