SnowPro Advanced Architect

CREATE OR REPLACE TABLE drops the prior table and creates a replacement with the same name, while retaining the dropped table in Time Travel. UNDROP TABLE returns an error if a table of that name already exists, so the replacement must first be renamed before the original employees table can be restored.