defncopy pulls just the stored procedure text. we have lot of procs that are using externally created hash tables [from parent proc or application ]. I am trying to build them with a different name [ say with a prefix ]. so defncopy does only part of the work, to build the proc, I need the hash table creation statement also in the front.
Do you guys know how to handle this situation. Also wondering how Rapid-sql is able to pull the temp table creation statement also.