Saturday, January 9, 2010

Find tables contain 'accountid' or 'account_id'

I'm using vtiger CRM, I used this query to find which tables contain column accountid or account_id so that I can understand the relationship among them.

SELECT * FROM information_schema.columns
WHERE column_name LIKE 'account_id'
OR column_name LIKE 'accountid'

No comments:

Post a Comment