sql server判定ライブラリ、テーブル、フィールドは存在しません

806 ワード

    
 IF EXISTS(SELECT * FROM sysobjects WHERE name='bbsUser')
 PRINT '  '    
 ELSE    
 PRINT '   '    --       
   
 if EXISTS(SELECT * FROM sys.sysdatabases WHERE name='bbsDB')
 PRINT '  '    
 ELSE    
 PRINT '   '   --         
  
 IF EXISTS (SELECT 1 FROM SYSOBJECTS T1 INNER JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID  WHERE T1.NAME='A' AND T2.NAME='C' )    
 PRINT '  '    
 ELSE    
 PRINT '   '    --   A    C    
 
 IF COL_LENGTH('A', 'C') IS NOT NULL    
 PRINT N'  '    
 ELSE    
 PRINT N'   '  --   A    C    

 IF NOT EXISTS (	SELECT * FROM  table WHERE  Bh='A')
 begin
 print '   '
 end             --    table        Bh='A'