/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 vote199 views2 answers
Pad zero sql server
SQL
0 vote194 views1 answer
Formatting code with SQL Developer
SQL
0 vote236 views1 answer
Search In the Data using ObjectName
SQL
1 vote186 views2 answers
Mysql order by date asc null last
SQL
0 vote186 views1 answer
Get number of rows in every table mysql
SQL
1 vote200 views1 answer
Mysql show table character set
SQL
1 vote194 views1 answer
Base nosql
SQL
0 vote190 views1 answer
Can we rollback deleted data in sql
SQL
0 vote255 views2 answers
Suse stop MySQL
SQL
0 vote211 views1 answer
Foreign key multiple columns
SQL