/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 vote380 views1 answer
Floor function in sql oracle
SQL
0 vote384 views1 answer
Write SQL in ruby on rails
SQL
4 votes336 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
1 vote341 views1 answer
Sysdate in sql
SQL
0 vote321 views1 answer
How to find unique key in sql
SQL
1 vote402 views1 answer
Opensuse restart MySQL
SQL
0 vote393 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote344 views4 answers
Aggregate function in sql
SQL
0 vote328 views1 answer
Sum value by month sql
SQL
9 votes332 views3 answers
Oracle undo usage by session
SQL