/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 vote146 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote105 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote136 views1 answer
Luu ckeditor vao mysql
SQL
0 vote192 views1 answer
Contraint default SQL
SQL
6 votes141 views2 answers
Can't connect to local mysql server through socket
SQL
11 votes145 views1 answer
Oracle view source
SQL
0 vote162 views1 answer
To Create directory
SQL
0 vote182 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote141 views2 answers
Postgresql get difference in hours between two dates
SQL
6 votes143 views3 answers
Mysql first day of year
SQL