Some Important SQL Queries

EXEC sp_databases
 
EXEC sp_helpdb
 
SELECT name
FROM sys.databases
 
SELECT name
FROM sys.sysdatabases

SELECT *
FROM sys.Tables
 
SELECT * FROM information_schema.tables
 
SELECT * FROM sysobjects WHERE xtype='U'

SELECT name
FROM sys.objects
WHERE type = 'P'
If you want to find it within a period then;
 
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) <5

SELECT *
FROM sys.objects
WHERE type_desc LIKE '%FUNCTION%';