/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 vote143 views1 answer
Sql right characters
SQL
2 votes146 views1 answer
Oracle sql day of month from date
SQL
0 vote189 views1 answer
Find wordpress version in database
SQL
9 votes145 views4 answers
How to remove duplicate in sql
SQL
5 votes158 views2 answers
Sql server check port number
SQL
3 votes189 views1 answer
RENAME table pl sql
SQL
7 votes170 views2 answers
Postgres concat
SQL
5 votes181 views3 answers
Show indexes mysql
SQL
0 vote153 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote163 views2 answers
Postgresql variable in query
SQL