/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 vote134 views1 answer
Google cloud sql postgres url example
SQL
0 vote114 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote114 views1 answer
Group by 15 minute interval sql server
SQL
0 vote128 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
37 votes305 views3 answers
Sql check duplicate value in column
SQL
0 vote131 views1 answer
Import sql in postgresql
SQL
1 vote127 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote173 views1 answer
Sql alter table add column if exists
SQL
0 vote119 views1 answer
Mql5 list all available symbols
SQL
13 votes129 views1 answer
Select count of distinct values sql
SQL