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
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 |