/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 votes230 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
6 votes169 views2 answers
Mysql set primary key
SQL
0 vote205 views1 answer
Oracle to_number
SQL
0 vote185 views1 answer
Postgresql in vs any performance
SQL
0 vote170 views1 answer
Select all tables linked server sql
SQL
1 vote139 views1 answer
Unique vs distinct sql
SQL
0 vote191 views1 answer
T sql dynamic top n query
SQL
1 vote191 views1 answer
Raw query must include primary key
SQL
0 vote201 views1 answer
Postgres - Login and connect as default user
SQL
0 vote186 views1 answer
Create table using the clause with as
SQL