Catatan Pribadi Tentang Perintah SQL

Cek Tabel yang ada di database postgreSQL
SELECT table_name
FROM information_schema.tables
WHERE table_name LIKE ‘%mata%’ OR table_name LIKE ‘%mtk%’ OR table_name LIKE ‘%mk%’
AND table_schema = ‘public’;

Cek Struktur Tabel yang ada di database postgreSQL
SELECT column_name, data_type, is_nullable
FROM information_schema.columns
WHERE table_name = ‘m_mata_kuliah’
ORDER BY ordinal_position;