/////////////////////
SELECT * FROM sys.procedures WHERE create_date > '20191110' ---Particular for the procedure
SELECT * FROM sys.tables WHERE create_date > '20191110' ------Particularfor the table
SELECT * FROM sys.views WHERE create_date > '20181110' ------Particular for the View
SELECT * FROM sys.table_types - ----- Particular for the table type
---Get All operated type
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE CREATED > '20191010'
---Get All operated type
SELECT * FROM sys.objects WHERE DATEDIFF(D,modify_date, GETDATE()) < 7
/////////////////////////////////
No comments:
Post a Comment