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