For compare tables & structures of the tables take a look SQLTABLES() & SQLCOLUMNS() functions. About stored procedures, I don't know.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
