I'm presuming this is for Microsoft SQL Server, given DBO.SysObjects.This seems like an argument in favor of using consistent column names across your database.
Yup. It is great when things are consistent. I have another one I'm going to edit and get up here eventually that looks at each row - in each column - in each table across the database. It's a slow but through way of finding things like unique keys.