1. Retrieve the current definition of the table by querying the system catalog
or data dictionary.
2. Retrieve the current definition of any views that specify the table by
querying the system catalog or data dictionary.
3. Retrieve the current definition of any indexes defined on the table by
querying the system catalog or data dictionary.
4. Retrieve the current definition of any triggers defines on the table by
querying the system catalog or data dictionary.
5. Capture all referential constraints for the table and its related tables and
determine what their impact will be if the table is dropped.