Before alter Field name in table, Things Need to check

--00504502ae4728a16e047c685882
Content-Type: text/plain; charset=ISO-8859-1

Hi

For example ,

Student_TBL

Student_id Student_Name Student_regNo ,

Am going to Alter the StudentregNo To StudentRegister_No ,

Am not sure who are all used this field , that any of the views depend this
StudentRegister_No ,


How to check it ,

Is there any function Do this,


Thanks

--00504502ae4728a16e047c685882--

Re: Before alter Field name in table, Things Need to check

--000e0cd6cbe2cf1418047c76c13b
Content-Type: text/plain; charset=ISO-8859-1

you can take the help from "information_schema" .

--Anand

On Tue, Jan 5, 2010 at 4:01 PM, bharani kumar > wrote:

> Hi
>
> For example ,
>
> Student_TBL
>
> Student_id Student_Name Student_regNo ,
>
> Am going to Alter the StudentregNo To StudentRegister_No ,
>
> Am not sure who are all used this field , that any of the views depend this
> StudentRegister_No ,
>
>
> How to check it ,
>
> Is there any function Do this,
>
>
> Thanks
>

--000e0cd6cbe2cf1418047c76c13b--