[存在不存在][sql]（第一次散分）(不多 只有40)
--判断[数据库]是不是存在--------------------------------数据库名:master if exists(select * from [master]..[sysdatabases] where name=N'master') select 'true' else select 'false'--------------------------判断[表]是不是存在。--表名：[dbo].[a] use master go if exists (select * from dbo.sysobjects where (id = object_id(N'[dbo].[a]') and objectproperty/*对象财产*/ (id, N'IsUserTable') = 1)) select 'true' else select 'false' go----------------------------------------判断[临时表]是否存在 if object_id('tempdb.dbo.T_P') is not null --tempdb.dbo.T_P [临时表名] select '存在' else select '不存在'-------------------------------------[存储过程] 是否存在 --N'[dbo].[selectTabAById]': [存储过程名] if exists ( select * from dbo.sysobjects where id = object_id(N'[dbo].[selectTabAById]') and OBJECTPROPERTY(id, N'IsProcedure') = 1 ) select 'true' else select 'false' gocreate view --------------------------------------------[视图] 是否存在 -- [my_View_Users] :N'[dbo].[视图名]'if exists ( select * from dbo.sysobjects where id = object_id(N'[dbo].[my_View_Users]') and OBJECTPROPERTY(id, N'IsView') = 1) select 'true';else select 'false';----------------------------------------------- 判断[函数名]是否存在--函数名：[dbo].[DayOnly]if exists ( select * from dbo.sysobjects where id = object_id(N'[dbo].[DayOnly]') and xtype in (N'FN', N'IF', N'TF')) select 'true';else select 'false';----------------------------------------------