Skip to content

Instantly share code, notes, and snippets.

@bhavjot

bhavjot/gist:85227e5b437c1adb80136e698475f61c

Created April 24, 2019 02:42
Show Gist options
  • Save bhavjot/85227e5b437c1adb80136e698475f61c to your computer and use it in GitHub Desktop.
Save bhavjot/85227e5b437c1adb80136e698475f61c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Table can be dropped even when there is a view on it. There is no warning.
The associated view just becomes invalid when underlying table is dropped. 
Solution is to create a view "WITH SCHEMABINDING" option, which will give a warning, if there is any change in underlying table.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment