How to list all objects that are dependent on a table in Redshift

Run the below query to view all the dependent objects of a table in Redshift where schemaname and tablename are the names of the schema and table respectively.

select * from information_schema.view_table_usage where table_schema='schemaname' and table_name='tablename';
See also  How to create a table in Redshift database