/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 vote166 views1 answer
Sql server kill all connections
SQL
0 vote149 views1 answer
Mssql check if date is greater than today
SQL
-1 vote143 views1 answer
Mysql #1064 error
SQL
0 vote151 views2 answers
Oracle sql for each row
SQL
1 vote139 views1 answer
Sql not equal multiple columns
SQL
0 vote179 views1 answer
Select count concat string sql server
SQL
3 votes151 views1 answer
Sql replace character in string in all records
SQL
-2 votes156 views1 answer
Modify column name in tsql
SQL
1 vote148 views1 answer
SQL query to get all table records count from a database
SQL
3 votes171 views1 answer
What is having
SQL