sql server Åжϱí/ÊÓͼ/´æ´¢¹ý³ÌÊÇ·ñ´æÔÚ

--Èç¹ûÊÇʵ±í¿ÉÒÔÓÃ
if exists (select * from sysobjects where id = object_id(N'[dbo].[±íÃû]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[±íÃû]
--Èç¹ûÊÇÁÙʱ±í¿ÉÒÔÓÃ(˵Ã÷,Èç¹ûÓòéÕÒʵ±í·½·¨À´´òÁÙʱ±í»áÕÒ²»µ½.·¢²¼Çø±ð¶Ô´ú.)
if object_id('tempdb..##temp') is not null
   drop table ##temp
--Åжϴ洢¹ý³ÌÊÇ·ñ´æÔÚ
MSSQL2000
view plaincopy to clipboardprint?
if exists(select * from sysobjects where id=object_id('[dbo].[sp_create_storeCount]') and xtype='P')   
DROP PROCEDURE [dbo].[sp_create_storeCount] 
if exists(select * from sysobjects where id=object_id('[dbo].[sp_create_storeCount]') and xtype='P')
DROP PROCEDURE [dbo].[sp_create_storeCount] 
MSSQL2005
 view plaincopy to clipboardprint?
IF  EXISTS (SELECT * from sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AccountHz]') AND type in (N'P', N'PC'))  
DROP PROCEDURE [dbo].[AccountHz] 
IF  EXISTS (SELECT * from sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[AccountHz]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[AccountHz]
 
--ÅжÏÊÓͼÊÇ·ñ´æÔÚ
--SQL Server 2000
IF EXISTS (SELECT * from sysviews WHERE object_id = '[dbo].[ÊÓͼÃû]'
--SQL Server 2005
IF EXISTS (SELECT * from sys.views WHERE object_id = '[dbo].[ÊÓͼÃû]'
/*
sysObjects (
Name sysname,      --object Ãû³Æ
id   int,          --object id
xtype char(2),     -- object ÀàÐÍ  
type char(2),     -- Object ÀàÐÍ£¨Óëxtype ËƺõһģһÑù£¿ ÓеãÓôÃÆ…£©
uid   smallint,     -- object ËùÓÐÕßµÄID
...                --ÆäËûµÄ×ֶβ»³£Óõ½¡£  
)
sysobjectsµÄxtype ´ú±íµÄ¶ÔÏóÀàÐÍ¡£¿ÉÒÔÊÇÏÂÁжÔÏóÀàÐÍÖеÄÒ»ÖÖ£º
C = CHECK Ô¼Êø
D = ĬÈÏÖµ»ò DEFAULT Ô¼Êø
F = FOREIGN KEY Ô¼Êø
L = ÈÕÖ¾
FN =