Exercise

Finding the internal or external tables

You know that internal schemas can only have internal tables, but you want to continue to build up your documentation for all the tables. With that in mind, you decide to review the table types for all the tables in the public_intro_redshift schema.

Instructions

100 XP

Select the table name and type from the all tables system view.
Filter to just the public_intro_redshift.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise