Post reply

while alter a table it should say that column already related to some views.

  • July 4, 2010 at 4:50 am

    #226417

    I am having one table. Col1 and Col2, and i hav created a view with these two fields. once the col1 or col2 renamed or deleted by the user(who is having rights) it should says that the view is related to this fields. is it possible?

  • July 4, 2010 at 6:22 am

    #1188610

    Create the view WITH SCHEMABINDING, or you can implement a custom DDL trigger that checks dependencies and throws an error. The first is far easier

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 5, 2010 at 12:36 am

    #1188668

    Thanks Gail Shaw, Can you give some reference for the same or please give some example how it will work?

    Thanks in advance.

    Karthik

  • July 5, 2010 at 3:07 am

    #1188698

    Books Online?

    http://msdn.microsoft.com/en-us/library/ms187956%28SQL.90%29.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply