/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 vote128 views1 answer
Mysql order by on condition
SQL
0 vote136 views1 answer
Adding generated time in row mysql workbench
SQL
3 votes139 views2 answers
MySQL query to get column names
SQL
0 vote152 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote155 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
1 vote211 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote126 views1 answer
Get number of table colums in sql query
SQL
0 vote222 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
5 votes123 views5 answers
Sqlite install python
SQL
0 vote150 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL