使用re解析使用正则表达式在Python中解析ddl

I'm trying to remove temporary tables from a ddl of over 100 tables by parsing through a file using python and regex. I managed to get the result I want using I'm trying to remove temporary tables from a dd