```sql CREATE SCHEMA PROJECT_ID.DATASET_ID OPTIONS ( default_table_expiration_days = TABLE_EXPIRATION, location = 'LOCATION', ) ``` ```sql ALTER TABLE mydataset.mytable SET OPTIONS ( expiration_timestamp=TIMESTAMP "2025-01-01 00:00:00 UTC"; ```