Exercise 3.1: User Defined Types (UDTs)
ℹ️ For technical support, please contact us via email.
Create a UDT and add new columns to the table
✅ Create the encoding
UDT:
CREATE TYPE video_encoding (
bit_rates SET<TEXT>,
encoding TEXT,
height INT,
width INT
);
✅ Alter the videos
table to add columns tags
and encoding
:
ALTER TABLE videos ADD tags SET<TEXT>;
ALTER TABLE videos ADD encoding FROZEN<video_encoding>;