How to list all external Schemas in Redshift database

svv_external_schemas system catalog view provides list of all external schemas in your Redshift database.

SELECT * FROM svv_external_schemas;