/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

25 votes247 views5 answers
Mysql replace text
SQL
0 vote159 views2 answers
Delete the last item in a table sql
SQL
5 votes199 views2 answers
Sql server check port number
SQL
0 vote201 views1 answer
Sql server select record with max id
SQL
0 vote188 views1 answer
Mssql describe stored procedure sqlcmd
SQL
35 votes212 views5 answers
Sql alter column
SQL
3 votes192 views1 answer
Convert sqlite table to pandas dataframe
SQL
103 votes322 views1 answer
Like sql
SQL
6 votes195 views1 answer
Check Table Exists
SQL
16 votes201 views4 answers
Mysql import from sql file
SQL