Monday, May 26, 2025

alle tabellen / Spalten einer Datenbank mittels Select Abfrage zurückgeben

 In Oracle:

SELECT * FROM   all_tables where table_name like '%test%'

SELECT * FROM   all_tables where owner like 'test'

select * from all_tab_columns where Column_name like '%test%'


Allgemein Sql:

SELECT * FROM information_schema.tables;

No comments: