Snipplr

(SQL) Find a Column by Name in User Tables - kencyber

Mon, 14 Dec 2009 14:31:06 UTC

Perform a search of all user tables in the current database to locate a column defined in a user table that matches a certain name. The first query looks for an exact column name and the second one returns all column names which match a keyword (using the LIKE operator).

(SQL) Search functions for the occurance of a string - kencyber

Fri, 04 Dec 2009 13:23:09 UTC

Searches the code for all functions in the current database and returns results containing the function name, the character index where the first match was found, and a portion of the code where the match occurred.

(SQL) Search stored procedures for the occurance of a string - kencyber

Fri, 04 Dec 2009 13:15:15 UTC

Finds all procedures that contain any occurrence of a string. The results show the name of the procedure, the character index where the first match was found along with the portion of the code that matched the search term.