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.
Bu egzersiz
Introduction to Redshift
kursunun bir parçasıdırEgzersiz talimatları
- Select the table name and type from the all tables system view.
- Filter to just the
public_intro_redshift.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Query the table name and type
SELECT ___,
___
-- Use the proper system view to via all tables
FROM ___
-- Make sure to filter to the proper schema
WHERE schema_name = '___';