/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 vote263 views1 answer
Oracle list subpartitions
SQL
0 vote249 views1 answer
Backup a table in sql
SQL
0 vote241 views1 answer
Postgresql get current user name
SQL
3 votes270 views2 answers
Mysql config user password
SQL
9 votes256 views4 answers
How to remove duplicate in sql
SQL
0 vote258 views2 answers
Starting mysql service from mac
SQL
4 votes276 views2 answers
Mysql alter table set column unique
SQL
0 vote247 views1 answer
How to to get current date and time in sql
SQL
1 vote260 views1 answer
Change table to innodb mysql
SQL
0 vote256 views1 answer
Sql server order by nulls last
SQL