docstr: Get a list of all the tables in the database.
  
  Returns:
      Response: Names of the tables in the database.
docstr_tok: ["Get","a","list","of","all","the","tables","in","the","database",".","Returns",":","Response",":","Names","of","the","tables","in","the","database","."]
code: def get_tables(self) -> StatusResponse:
      """Get a list of all the tables in the database.
  
      Returns:
          Response: Names of the tables in the database.
      """
      if self.schema:
          query = f""" SELECT TABLENAME FROM SYSTEM.TABLES WHERE SCHEMA = '{self.schema}' """
      else:
          query = """ SELECT TABLENAME FROM SYSTEM.TABLES WHERE SCHEMA != 'SYSTEM' """
  
      result = self.native_query(query)
      df = result.data_frame
      result.data_frame = df.rename(
          columns={df.columns[0]: "table_name"}
      )
      return result
  
imports: from collections import OrderedDict
  from typing import Optional
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.utilities import log
  from mindsdb_sql import parse_sql
  from mindsdb.integrations.libs.response import HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  import pandas
  import jaydebeapi
label_desc: Use image node_id 8 for calling the NuoHandler obj's underlying member method code with example usage: obj.get_tables() and returns: result