/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 vote233 views3 answers
Mysql parse int
SQL
2 votes214 views2 answers
How to rename column name in sql server using query
SQL
0 vote237 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote228 views1 answer
TSQL convert csv to table
SQL
0 vote196 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
1 vote220 views3 answers
How to get date in sql
SQL
0 vote222 views1 answer
Flush user resource mysql
SQL
0 vote209 views1 answer
Time in sql server
SQL
3 votes200 views1 answer
Oracle function
SQL
5 votes201 views2 answers
Mysql where in array
SQL