```SELECT DISTINCT TABLE_NAME FROM INFORMATIO...

# exposed

[Mihael]

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('SessionId')
        AND TABLE_SCHEMA='YourDatabase';

[tapac]

val result = ColumnsTable.
     slice(ColumnsTable.tableName).
     select { 
         ColumnsTable,columnName inList listOf("SessionId") and 
         ( ColumnsTable.tableSchema eq "YourDatabase"}.
      withDistinct().map {             it[ColumnsTable.tableName]
  }

[Mihael]

Thank you