Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
Views or tables participating in a view created with the SCHEMABINDING clause cannot be dropped. If the view is not created using SCHEMABINDING, then we can drop the table.