/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

9 votes383 views3 answers
Mysql run sql file
SQL
0 vote358 views1 answer
Create function in microsoft sql server
SQL
0 vote348 views1 answer
Fetch second word from a string in ms sql
SQL
3 votes362 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote327 views1 answer
How many columns can be used for creating index?
SQL
1 vote354 views1 answer
Raw query must include primary key
SQL
0 vote339 views1 answer
TSQL function split string
SQL
35 votes358 views6 answers
Postgres
SQL
13 votes367 views2 answers
Sql online compiler
SQL
2 votes356 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL