/SQL/Sql server query all database objects

Sql server query all database objects

SELECT 
	obj.name, 
    obj.type_desc, 
    SCHEMA_NAME (obj.schema_id ) as schema_name
FROM
	sys.objects obj
WHERE
	obj.type in (  'P' ) and obj.name like '%XYZ%'
ORDER BY
	1

Similar codes

2 votes262 views1 answer
Guid to string sql
SQL
9 votes261 views4 answers
SQL Date Format
SQL
4 votes248 views2 answers
Mysql select where starts with
SQL
0 vote257 views1 answer
Postgresql function ROUND
SQL
0 vote253 views1 answer
Mariadb errno 121
SQL
0 vote258 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
12 votes256 views5 answers
Sql merge
SQL
0 vote251 views4 answers
Rownum in sql
SQL
10 votes209 views2 answers
Django mysql
SQL
42 votes332 views6 answers
Rename table sql server
SQL