Is it possible to have the SHOW TABLE command not show the database name on the output?
just display the tablename?
I do not believe it is possible. SHOW TABLE is a standard statement that can be submitted from SQLAssistant, BTEQ or any application. The default output is to append the database name. There is no such option to alter the output.