CREATE VIEW Side Effects - Select * Pitfalls | Essential SQL
Get the course today at: https://www.udemy.com/course/stored-p...
So what happens when you create a view, and then late someone else changes the underlying tables? In this article let's explore a simple scenario, check out how the SQL view handles the change, and what we can learn from viewing the data dictionary.
You can also read about this at https://www.essentialsql.com/create-v...