How to find Tables, Stored Procedure Created in Sql Database


Posted on January 6th, 2015 by Hitesh Kumar | 307 Views

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

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

Comments are closed.