SqlDbx
You are not logged in.
Pages: 1
Alex -
Can you add a COLUMN checkbox to the 'Tools/Search In Database' dialog? In large customer databases, this is needed to prospect for fields you may be looking for, but aren't sure of the name. I currently do a search on the "TABLE" option for smaller databases to find them, however the larger the database, the longer the wait time. (Current one is 1800 tables...would take forever).
Instantaneous results can be retrieved in MSSQLServer via the sql:
SELECT TABLE_NAME, COLUMN_NAME FROM information_schema.columns WHERE COLUMN_NAME LIKE '%<argument>%'
Thx,
BlueSmoke...
Last edited by Allen (2012-01-17 11:55:14)
Offline
Pages: 1