Database	Proc	Application	Created	Links
sybsystemprocs	sp_droptabledef		31 Aug 14	Defects Dependencies

1     
2     /* Sccsid = "%Z% generic/sproc/src/%M% %I% %G%" */
3     
4     /* 
5     ** Omni only
6     */
7     create 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: 30%	7
MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 1 = 0dec - 1exi + 2	7
MTR3 2 Metrics: Query Complexity Complexity: 4	7

DEPENDENCIES

PROCS AND TABLES USED calls proc sybsystemprocs..sp_dropobjectdef      read_writes table sybsystemprocs..sysattributes      reads table sybsystemprocs..sysobjects