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)

Related posts:

  1. How to get month names between date ranges in sql.
  2. How to find n’th highest salary from table in sql server
  3. Find Mirror image of the string

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

Comments are closed.