/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 vote354 views3 answers
Osx stop mysql service
SQL
0 vote388 views1 answer
Recently updated stored procedure in sql server
SQL
10 votes333 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote380 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote403 views1 answer
Tsql cte in a transaction
SQL
23 votes356 views2 answers
Query to delete a database in mysql
SQL
2 votes356 views2 answers
Sql percentage
SQL
2 votes328 views1 answer
Docker run postgres locally
SQL
0 vote370 views2 answers
Sql having multiple conditions
SQL
0 vote396 views1 answer
How to find date from date table in sql
SQL