Ways to display tables' names in diferent DB

describe_table.sql

-- redshift/postgres
select column_name,data_type
from information_schema.columns
where table_name = 'table_name';


-- databricks
describe table tablename;

select_tables_from_DB.sql

-- sqlite
select 
    name
from sqlite_master 
where type ='table'
    and name not like 'sqlite_%';
    
-- redshift/postgres
select tablename
from pg_table_def 
where schemaname = 'public';

-- Databricks
show tables;