Grant Fritchey
SSC Guru
Points: 399330
More actions
July 30, 2015 at 4:27 am
#1816052
You can create the view using WITH SCHEMABINDING. That will prevent the table from being modified. Here's the CREATE VIEW syntax.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
fnndala2
SSC Enthusiast
Points: 118
July 31, 2015 at 3:42 am
#1816377
Thank you, that works
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply