/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 vote260 views1 answer
Sql get missing id
SQL
0 vote278 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote268 views1 answer
How to create a new shema using query languaage
SQL
1 vote279 views4 answers
Aggregate function in sql
SQL
0 vote267 views1 answer
Mysql find db contarint
SQL
0 vote371 views2 answers
Sqlalchemy default value for column
SQL
0 vote286 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
9 votes289 views4 answers
Mysql set id auto increment
SQL
0 vote261 views1 answer
Drop all procedures sql server
SQL
1 vote310 views1 answer
Alter database datafile maxsize 32g
SQL