/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

3 votes123 views1 answer
Query less than datetime sql
SQL
0 vote118 views1 answer
Plsql find location of procedure
SQL
0 vote112 views1 answer
Sql delimiter to columns
SQL
3 votes128 views2 answers
Update part of a string in mysql
SQL
1 vote115 views1 answer
Round function in sql oracle
SQL
0 vote123 views1 answer
Find and replace database table phpmyadmin
SQL
2 votes141 views1 answer
Find column in all stored procedures sql server
SQL
1 vote127 views1 answer
Load mysql dumb
SQL
0 vote124 views1 answer
Oracle sql all days except weekends
SQL
0 vote117 views1 answer
How to get data between a last week in mysql
SQL