阅读背景:

当删除视图的一部分字段时,SQL服务器不会发出警报

来源:互联网 

I just don´t understand why SQL Server doesn´t throw an error when you delete a column from a table, and that column is read by a View. To my understanding, SQL Server has that information, knows which columns/tables are read when you do a select query from a view, so i think it shoulnd´t let you delete a column referenced from a view, just like it doesn´t allow you to remove a column referenced by a FK... There has to be an explanation to this, please someone tell me! Thanks a lot.I just don´t understand why SQL Server doesn´t




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: