分享至
大家好,請問一個問題我想知道我某個實體table到底有哪幾個view去參考使用到了,語法上應該如何下呢?
已邀請的邦友 {{ invite_list.length }}/5
請參閱
謝謝
How to find which views are using a certain table in SQL Server (2008)?
https://stackoverflow.com/questions/9618134/how-to-find-which-views-are-using-a-certain-table-in-sql-server-2008
SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE VIEW_DEFINITION like '%YourTableName%'
謝謝,已解決!
IT邦幫忙