dplaut
New Contributor II

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';