Wednesday, February 17, 2016

Find detail about Stored Procedure or Table


How to know table or columnname used in which stored procedure?


select * from sys.sql_modules where definition like '%id%'

How to know “stored procedure” created and modified date?


SELECT name, create_date, modify_date FROM sys.objects
WHERE type = 'P'

How to know “table” created and modified date?


SELECT name, create_date, modify_date FROM sys.objects
WHERE type = 'U'


How to know “view” created and modified date?


SELECT name, create_date, modify_date FROM sys.objects
WHERE type = 'V'

No comments:

Post a Comment