DatabaseProcApplicationCreatedLinks
sybsystemprocssp_droptabledef  14 déc. 14Defects Propagation Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/src/%M% %I% %G%" */
3     
4     /* 
5     ** Omni only
6     */
7     create or replace procedure sp_droptabledef
8         @tablename varchar(767) /* table name */
9     as begin
10            declare @status int
11    
12            exec @status = sp_dropobjectdef @tablename
13            return (@status)
14        end
15    


exec sp_procxmode 'sp_droptabledef', 'AnyMode'
go

Grant Execute on sp_droptabledef to public
go
DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_droptabledef  
 MNER 3 No Error Check should check return value of exec 12
 MUCO 3 Useless Code Useless Begin-End Pair 9
 MUCO 3 Useless Code Useless Brackets 13
 MTR1 2 Metrics: Comments Ratio Comments: 15% 7
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 7
 MTR3 2 Metrics: Query Complexity Complexity: 4 7

DEPENDENCIES
PROCS AND TABLES USED
calls proc sybsystemprocs..sp_dropobjectdef  
   calls proc sybsystemprocs..sp_aux_checkroleperm  
      reads table master..syscurconfigs (1)  
      reads table master..sysconfigures (1)  
   reads table sybsystemprocs..sysobjects  
   read_writes table sybsystemprocs..sysattributes