/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

5 votes123 views1 answer
Mysql where one year ago
SQL
0 vote109 views1 answer
Timestamp(0) postgresql
SQL
0 vote112 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote154 views1 answer
Update sql sintax
SQL
2 votes111 views2 answers
Change varchar length mysql
SQL
0 vote127 views1 answer
Mysql get nth highest
SQL
2 votes113 views2 answers
Enable foreign key checks postgres
SQL
0 vote132 views3 answers
Mysqli count down
SQL
0 vote132 views1 answer
Authentication modes in sql server
SQL
11 votes107 views1 answer
Oracle view ddl
SQL