Michael Bayer (@zzzeek) wrote:

well, MySQL has no feature whatsoever to do this: http://dev.mysql.com/doc/refman/5.5/en/tables-table.html http://stackoverflow.com/a/16296395/34549

Michael Bayer (@zzzeek) wrote:

so.... I'm going to support reflection of the table, but yank it out of the list for sqlite. its inconsistent

Michael Bayer (@zzzeek) wrote:

we'll move the list-based methods into new inspector methods for temp tables and temp views.

Michael Bayer (@zzzeek) wrote:

• Added :meth:.Inspector.get_temp_table_names and
  :meth:.Inspector.get_temp_view_names; currently, only the
  SQLite dialect supports these methods. The return of temporary
  table and view names has been removed from SQLite's version
  of :meth:.Inspector.get_table_names and
  :meth:.Inspector.get_view_names; other database backends cannot
  support this information (such as MySQL), and the scope of operation
  is different in that the tables can be local to a session and
  typically aren't supported in remote schemas.
  fixes temporary table reflection #3204

→ cb23fa2

Changes by Michael Bayer (@zzzeek):

• changed status to closed

Michael Bayer (@zzzeek) wrote:

Oracle too.

Michael Bayer (@zzzeek) wrote:

• Added support for the Oracle table option ON COMMIT. This is being
  kept separate from Postgresql's ON COMMIT for now even though ON COMMIT
  is in the SQL standard; the option is still very specific to temp tables
  and we eventually would provide a more first class temporary table
  feature.
• oracle can apparently do get_temp_table_names() too, so implement that,
  fix its get_table_names(), and add it to temporary table reflection #3204. fixes temporary table reflection #3204 again.

→ e3f07f7