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’

Advertisements