/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 vote208 views1 answer
Sql clear table
SQL
4 votes205 views1 answer
Postgresql change default value
SQL
1 vote198 views1 answer
Is sql fast
SQL
0 vote216 views1 answer
How to install postgresql on wsl
SQL
0 vote194 views1 answer
Sql select min row
SQL
2 votes205 views2 answers
How to check database username and password in postgresql
SQL
1 vote214 views1 answer
How to group by month using sql server
SQL
1 vote205 views2 answers
Restart identity cascade
SQL
0 vote210 views1 answer
Mssql disable foreign key constraint
SQL
0 vote210 views1 answer
How to check which table has data in mysql
SQL