How to find Tables, Stored Procedure Created in Sql Database


To find tables, stored procedures in sql database

SELECT A.name AS [Object Name],
S.[name] [Schema Name],
A.type_desc [Description],
A.create_date [Creation Date],
A.modify_date [Modified Date]
FROM  sys.all_objects A
LEFT OUTER JOIN sys.schemas S
ON A.schema_id = S.schema_id
WHERE  create_date > (GETDATE() - 15) OR modify_date > (GETDATE() - 15)

One thought on “How to find Tables, Stored Procedure Created in Sql Database

Comments are closed.