/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

0 vote254 views1 answer
Left join vs inner join performance
SQL
0 vote197 views1 answer
Print sum of values sql
SQL
0 vote238 views2 answers
Oracle sql for each row
SQL
0 vote256 views1 answer
Postgres dump sql insert
SQL
0 vote253 views1 answer
Sql server get date of previous sunday
SQL
0 vote224 views1 answer
How much table store postgres
SQL
3 votes233 views4 answers
Mysql decimal
SQL
1 vote258 views1 answer
Update from select oracle
SQL
0 vote232 views1 answer
Sql query to select records entered in last 24 hours
SQL
2 votes238 views1 answer
Wait delay in sql server
SQL