ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK Query to find the constraints details of a table in DB. INNER JOIN AS sj ON sja.job_id = sj.job_id WHERE definition LIKE work to find the given text in procedures/functions/triggers from selected DB.īelow query works to check the job status of SQL Server Agent Jobs: SELECT sj.name
Where query above in accepted answer SELECT OBJECT_NAME(object_id), definition WHERE js.command LIKE N'%YOUR TEXT HERE%' JOIN s ON s.srvid = j.originating_server_id JOIN dbo.sysjobsteps js ON js.job_id = j.job_id SELECT j.job_id, s.srvname, j.name, js.step_id, js.command, j.enabled This is also a helpful query to find something like proc etc from msDB means this will find table/function/proc ref in SQL Server Agent's Jobs. As this query does not search in these areas. ' WHERE ' + + ' LIKE ' + ColumnName, ColumnValue FROM I like to search given string in the procedures/functions/triggers as well is there any query exist in SQL Server 2005. QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)ĪND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')ĪND QUOTENAME(COLUMN_NAME) > IS NOT NULL SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))ĪND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > OBJECTPROPERTY( This Query can search any string value (table name, table data etc) from all the tables/views of any SQL Server database, when you will place any string at " your text here" it will search your given string from all the tables/views exist in that database, DECLARE nvarchar(100)ĭECLARE TABLE(ColumnName nvarchar(370), ColumnValue nvarchar(3630))ĭECLARE nvarchar(256), nvarchar(128), nvarchar(110)
0 kommentar(er)
