Save output of show table extended to table?

[dplaut]

I want to save the output of 

    show table extended in catalogName like 'mysearchtext*';

to a table.

How do I do that?

[dplaut]

I can't get this to work. I get the error:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'SHOW'.line 2, pos 0

insert into my_target_table (database, tablename, istemporary, information)
SHOW TABLE EXTENDED LIKE 'mytable';

[dplaut]

I would not have expected that to work as it violates rules I know about SQL and the purpose of the semicolon. And it does not work.

[PARSE_SYNTAX_ERROR] Syntax error at or near end of input.line 1, pos 75