How to know how many tables contains empno as a column in a database?

Hi Friends ,i am writing this article  to know how many tables contains empno as a column in a database?

SELECT COUNT(*) AS Counter
FROM syscolumns
WHERE (name = 'empno')