Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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
Comment

PREVIOUS NEXT
Code Example
Sql :: insert query return id mysql 
Sql :: sql backup database statement 
Sql :: select all tables sql 
Sql :: install postgresql centos 5 
Sql :: postgresql to_char time 
Sql :: select and condition in sql 
Sql :: sql add column to table 
Sql :: mysql trim 
Sql :: foreign key mysql 
Sql :: sql date get month 
Sql :: create pl/sql stored procedure 
Sql :: mysql insert value date 
Sql :: sql distinct with count 
Sql :: backup a table in sql 
Sql :: command line mysql xampp 
Sql :: sql column contains special character 
Sql :: login to mysql database 
Sql :: sql mm/dd/yyyy format 
Sql :: how to extract year from date in sql 
Sql :: Check user permissions on postgres database 
Sql :: mysql clear screen 
Sql :: select new table sql 
Sql :: sequelize migration default value 
Sql :: oracle log files 
Sql :: date sql get the last week count 
Sql :: sql convert varchar to date 
Sql :: oracle list grants on package 
Sql :: use float in sql server string 
Sql :: sql declare variable 
Sql :: sqlite get last 
ADD CONTENT
Topic
Content
Source link
Name
4+3 =