CREATE VIEW Side Effects - Select * Pitfalls | Essential SQL

Get the course today at: https://www.udemy.com/course/stored-procedures-unpacked-learn-to-code-t-sql-stored-procs/?couponCode=SPUYOUTUBE202209 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-view-side-effects/