/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

1 vote133 views1 answer
How to remove identity from a column in sql server
SQL
-1 vote149 views3 answers
PS5
SQL
0 vote139 views1 answer
Postgresql check total storage
SQL
10 votes86 views2 answers
Django mysql
SQL
4 votes136 views2 answers
Oracle drop job
SQL
0 vote149 views1 answer
Mariadb disable foreign key checks
SQL
0 vote140 views1 answer
View psql output in horizontal scrolling
SQL
6 votes146 views4 answers
Mysql get random row
SQL
5 votes132 views1 answer
Sql use database
SQL
3 votes165 views3 answers
Restart mysql mac
SQL