/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 vote196 views2 answers
Mysql filter by date mount
SQL
0 vote191 views1 answer
Sql examples from your work
SQL
3 votes184 views1 answer
Select without null values sql
SQL
0 vote186 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote225 views1 answer
Sql select lowest value row
SQL
1 vote285 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
2 votes194 views2 answers
Sql first character
SQL
6 votes197 views1 answer
Sqlite foreign key
SQL
5 votes217 views1 answer
Oracle asynchronous query
SQL
5 votes184 views1 answer
Postgres integer to serial
SQL