Post reply

A view with encryption and Schema binding

  • November 14, 2008 at 11:26 am

    #193797

    Hi,

    I have a question on database views.

    I created a view on a table "with encryption" and "with schema binding" options. So I can't drop my table and at the same time I can't see the view created on the table. Let us say, if I need to drop the table and I forgot the view name (Becasue I have to drop the view first before dropping the table), how can I perform this action ?

    Thanks,

    Satish

  • November 14, 2008 at 1:39 pm

    #898868

    you can right click the table name in SSMS and choose view dependencies. This should show you any views that use that table.

  • November 15, 2008 at 6:31 am

    #898973

    🙂 So Simple, Thank you. Is there any other way to find out through writing a query ??

    Once again Thank you very much for your quick reply.

    -Satish

  • November 15, 2008 at 1:39 pm

    #899012

    You can use the sys.dm_sql_referencing_entities dmv to get information on entities that are referencing your table

    for e.g.

    USE msdb

    SELECT * FROM sys.dm_sql_referencing_entities('dbo.sysmail_mailitems','OBJECT')

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

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