/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 vote135 views1 answer
Full text index mysql
SQL
-1 vote189 views1 answer
What is in operator
SQL
1 vote220 views1 answer
Postgresql blocked on mac
SQL
0 vote184 views1 answer
Sql not exists
SQL
10 votes240 views4 answers
Else if mysql
SQL
14 votes196 views2 answers
Oracle export trigger ddl
SQL
0 vote191 views4 answers
Sql rownum
SQL
0 vote290 views1 answer
Multiple replace value mssql
SQL
39 votes279 views4 answers
Select duplicates in sql
SQL
9 votes233 views1 answer
No sql
SQL