Changing Field Name in Table 1

[deejay33]

Hello All,

I need to change a field name and type in on of our tables. It will go from a Y/N to character. Is there anyway to get a list of all the tables and forms that the field is used in? That way I can go in and fix all of the queries the changed name will break.

Thanks for that help!

Daniel Joaquin

 

[rjoubert]

SELECT * FROM MSysQueries WHERE Expression LIKE '*YourFieldName*'

 

[rjoubert]

Actually, this would work better...it gives you the name of the query...

SELECT MSysObjects.Name, *
FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId = MSysObjects.Id
WHERE (((MSysQueries.Expression) Like '*YourFieldName*'));

 

[deejay33]

Wow that worked great! Thanks so much!

Daniel Joaquin