Common SQL judgment and detection statements

SQL
-- ----------------------------------------------------------
-- Determine whether the database exists
If   Exists (
Select   *
From Master.. sysdatabases
Where Name = N ' Dbname '
)
Print ' Exists '
Else  
Print ' Not exists '
-- ----------------------------------------------------------
-- Determine whether the table name to be created exists
If   Exists (
Select   *
From DBO. sysobjects
Where ID =   Object_id (N ' [DBO]. [tablename] ' )
And Objectproperty (ID, n ' Isusertable ' ) =   1
)
Print ' Exists '
Else  
Print ' Not exists '
-- ----------------------------------------------------------
-- Determine whether the temporary table to be created exists
If   Object_id ( ' Tempdb. DBO. # tempdbname ' ) Is Not Null
Print ' Exists '
Else  
Print ' Not exists '
-- ----------------------------------------------------------
-- Determine whether the stored procedure name to be created exists
If   Exists (
Select   *
From DBO. sysobjects
Where ID =   Object_id (N ' [DBO]. [spname] ' )
And Objectproperty (ID, n ' Isprocedure ' ) =   1
)
Print ' Exists '
Else  
Print ' Not exists '
-- ----------------------------------------------------------
-- Determine whether the view name to be created exists
If   Exists (
Select   *
From DBO. sysobjects
Where ID =   Object_id (N ' [DBO]. [viewname] ' )
And Objectproperty (ID, n ' Isview ' ) =   1
)
Print ' Exists '
Else  
Print ' Not exists '
-- ----------------------------------------------------------
-- Determine whether the name of the function to be created exists
If   Exists (
Select   *
From DBO. sysobjects
Where ID =   Object_id (N ' [DBO]. [funname] ' )
And Xtype In (N ' FN ' , N ' If ' , N ' TF ' )
)
Print ' Exists '
Else  
Print ' Not exists '
-- ----------------------------------------------------------
-- Determine whether the column name to be created exists
If   Exists (
Select O. Name As Tablename,
C. Name As Columnname
From Sysobjects o Inner
Join Syscolumns C
On O. ID = C. ID
Where O. Name =   ' Tablename '
And C. Name =   ' Columnname '
)
Print ' Exists '
Else  
Print ' Not exists '
-- ----------------------------------------------------------
-- Or
If   Exists (
Select   1
From Sysobjects
Where ID In ( Select ID
From Syscolumns
Where Name =   ' Columnname ' )
And Name =   ' Tablename '
)
Print ' Exists '
Else  
Print ' Not exists '
-- ----------------------------------------------------------
-- Or
If   Col_length ( ' Tablename ' , ' Columnname ' ) Is Null
Print ' Not exists '
Else  
Print ' Exists '