[SQLServer]Consultas úteis para pesquisas

sql.sql

-- Busca por nome de objeto
SELECT
	cast(
		O.NAME as varchar
	) AS NOME_OBJETO,
	cast(
		O.type_desc as varchar
	) AS TIPO_OBJETO
FROM
	SYS.OBJECTS O
WHERE
	O.NAME LIKE '%NOME DO OBJETO%'
ORDER BY
	O.type_desc,
	O.NAME
 
-- Busca por nome de campo
SELECT
	cast(
		C.NAME as varchar
	) AS NOME_COLUNA,
	cast(
		O.NAME as varchar
	) AS NOME_OBJETO,
	cast(
		O.type_desc as varchar
	) AS TIPO_OBJETO
FROM
	SYS.COLUMNS C
INNER JOIN SYS.OBJECTS O ON
	C.OBJECT_ID = O.OBJECT_ID
WHERE
	C.NAME LIKE '%NOME DO CAMPO%'
ORDER BY
	O.type_desc,
	O.NAME

-- Busca informação dentro de uma VIEW ou SP
select
	cast(
		O.NAME as varchar
	) AS 'NOME_OBJETO',
	cast(
		O.type_desc as varchar
	) AS 'TIPO_OBJETO'
FROM
	sys.sql_modules m
INNER JOIN sys.objects o ON
	m.object_id = o.object_id
where
	m.definition like '%$(CURRENT_WORD)%'
order by
	O.type_desc,
	O.NAME
	
	
-- sp_help
-- sp_helptext