Find Database, Tables, Procedure Names in SQL Server

Find all database names in sql server

select name from sys.databases

Find all tables names in sql server for perticular database

select Table_name from information_schema.tables

Find all procedure names in sql server for perticular database

select name from sys.procedures where object_definition(object_id) not like ‘%sp%’

SELECT name FROM sys.objects WHERE type = ‘P’

Share