/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

5 votes294 views1 answer
Oracle nls instance
SQL
0 vote296 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote297 views1 answer
Get a list of tables and the primary key
SQL
1 vote270 views1 answer
Input in mysql
SQL
0 vote280 views1 answer
Sql select with apostrohpe
SQL
0 vote288 views1 answer
Mysql readable output
SQL
0 vote269 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote224 views1 answer
How to get last client id sql
SQL
0 vote312 views1 answer
Alter table add check constraint oracle
SQL
0 vote274 views1 answer
Left join in codeigniter query builder
SQL