Skip to content

Instantly share code, notes, and snippets.

@habibillah

habibillah/GetStoredProcedureRelatedToTableOrView.sql

Created July 24, 2012 03:21
Show Gist options
  • Save habibillah/3167824 to your computer and use it in GitHub Desktop.
Save habibillah/3167824 to your computer and use it in GitHub Desktop.
Download ZIP
Get stored procedure related to table or view on MSSQL SERVER
Raw
GetStoredProcedureRelatedToTableOrView.sql
SELECT DISTINCT sysobjects.name, sysobjects.xtype
FROM syscomments
INNER JOIN sysobjects ON syscomments.id=sysobjects.id
WHERE syscomments.TEXT LIKE '%table_name_or_view%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment