SQL Practice Logo

SQLPractice Online

Level 5 - SeniorQuery-Based Questions

Online Rename Strategy via View Shield

Interviewer prompt: You need to rename column users.mobile to users.phone_number without breaking old application code during rollout. Write SQL steps using compatibility view approach.

Schema Context

users(user_id, mobile, email)