```SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('Sessio...
m
Copy code
SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('SessionId')
        AND TABLE_SCHEMA='YourDatabase';
t
Copy code
val result = ColumnsTable.
     slice(ColumnsTable.tableName).
     select { 
         ColumnsTable,columnName inList listOf("SessionId") and 
         ( ColumnsTable.tableSchema eq "YourDatabase"}.
      withDistinct().map {             it[ColumnsTable.tableName]
  }
m
Thank you