/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

0 vote238 views1 answer
What is common table expression in sql
SQL
2 votes182 views1 answer
Column names in oracle sql
SQL
0 vote178 views1 answer
Show mysql account privilleges
SQL
1 vote171 views1 answer
Last 6 months postgresql
SQL
0 vote170 views1 answer
Call rest api from postgresql
SQL
0 vote164 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
2 votes172 views3 answers
How to pass password mysql command line
SQL
3 votes167 views4 answers
Mysql create table from select statement
SQL
1 vote196 views3 answers
Mysql parse int
SQL
0 vote173 views1 answer
Get first 3 letter of department name in sql
SQL