Re: how to refresh objects if a column changes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Prasad Koukuntla (prasad.koukuntla_at_scapromo.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 16:43:24 -0500

Look at the INFORMATION_SCHEMA.ROUTINES view and perform a wildcard search
in the ROUTINE_DEFINITION column for the column name whose data type
changed.

"rajani" <rajani@discussions.microsoft.com> wrote in message
news:2CC754D5-6E44-4DFA-9CA7-E8520D16BA61@microsoft.com...
> Hi friends
> I have a column (staffid varchar(5)) in a table staff.it stores our staff
info.
> our requirements grown we need to increase column length to varchar(10).
> there r many stored procs,function etc., that r currently using this
field.
> my question is what is best way to get list of objects that referencing
this column so that i could modify them to reflect new chnage?
> --
> cheers

Relevant Pages

  • Re: how to gain numbers
    ... dear friends i do know to use Text data type instead of number data type if ... i am not using that field for calculation but dear friends i am using the ... In the second column of the design grid, next to the name, you can select the ... *better* than a Number field in that you can store leading zeros. ...
    (microsoft.public.access.queries)
  • Re: Wildcard search within strings?
    ... Create your own wildcard search for strings. ... Or let's do it together with all the friends here. ... enjoy watching, though, and asking a zillion questions! ...
    (microsoft.public.word.vba.general)
  • RE: Errors while inserting into long data type
    ... > Hi Friends, ... > I am using oracle database and I have column of long data type. ... Ronald ...
    (perl.dbi.users)
  • Re: date and datetime
    ... > But when I connect from VFP using DSN, it returns the value as date/time. ...
    (microsoft.public.fox.vfp.dbc)