Is there a way I can get the original CreateText from DBC tables ? In a word, no. Some of the information in "show table" comes from the
table headers and is not stored in DBC tables.
Why not give the users CHECKPOINT access to the databases? This would be harmless and would allow them to run "show" on the objects.