02 August,2011 by Tom Collins
I use ADMIN_DROP_SCHEMA to drop a schema and its objects. The main advantage of using the procedure , instead of writing a customised script is there could be routines such as stored procedures or UDFs with cross dependencies and require to be dropped in a certain order.
An example is
CALL SYSPROC.ADMIN_DROP_SCHEMA ( schema_name, NULL, 'error_table_schema','error_table_name') ---Use this sql to view the errors: SELECT * FROM error_table_schema.error_table_name
Certain objects are not dropped using the ADMIN_DROP_SCHEMA procedure.
Check the DB2 documentation for details
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |