/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 vote200 views2 answers
Postgresql list columns
SQL
2 votes219 views2 answers
Sqlite_busy: database is locked
SQL
1 vote226 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote207 views1 answer
Group by join columns per table
SQL
3 votes208 views2 answers
Oracle for loop
SQL
0 vote198 views1 answer
Pl sql disable trigger
SQL
-1 vote206 views3 answers
My sql alter table
SQL
0 vote335 views3 answers
Osx stop mysql service
SQL
2 votes302 views1 answer
Oracle run_duration to number
SQL
0 vote205 views1 answer
Insert array into mysql column
SQL