/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

4 votes232 views1 answer
Create db table
SQL
0 vote243 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
2 votes225 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote226 views1 answer
Console output pl sql
SQL
0 vote235 views1 answer
Mysql subdate
SQL
4 votes223 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote247 views1 answer
SQL Cut part string
SQL
0 vote207 views1 answer
Heavy table in mysql
SQL
3 votes176 views1 answer
How to get list of synonyms in oracle
SQL
3 votes232 views2 answers
Postgres inner join vs join
SQL