/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 vote153 views1 answer
Selecting specific day in colum sql
SQL
0 vote106 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote96 views1 answer
Power bi find all ids not in other tables
SQL
0 vote118 views1 answer
Sql query use select name inside where clause
SQL
0 vote109 views1 answer
Open postgresql.conf in centos
SQL
0 vote115 views1 answer
How to inner join 4 tables in sql
SQL
0 vote107 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote117 views1 answer
Gcloud sql instance list
SQL
1 vote130 views1 answer
Count of tables in database mysql
SQL
0 vote99 views2 answers
Psql commande \gset
SQL