/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

36 votes345 views6 answers
Change column data type sql
SQL
0 vote284 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote262 views1 answer
Oracle last connection
SQL
1 vote282 views1 answer
Pl sql ptint
SQL
1 vote293 views2 answers
Oracle list service names
SQL
0 vote275 views1 answer
Mysql docker image arjun
SQL
-1 vote305 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
3 votes255 views2 answers
Having in mysql
SQL
2 votes302 views2 answers
Mysql on duplicate key update get value from values
SQL
1 vote289 views1 answer
Raise application error in oracle
SQL