i need to find a table in my DB how to do it will QA

i have a app that runs on sql. i need to fine a table in it to make
changes. the table should have a field in it call translations patterns"
in it. what the cmds for QA do i use and what else do i need to do to see
whats this table tide to. Please help
James Grace
System Engineer /Professional Srvc.
MCSE MCSA MCDBA CCNA CCNP CQS
You could use the Object Search feature in Query Analyzer. Just open QA, hit
F4 to oben Object Search, type the column name into the Object Name textbox
and select Column checkbox and hit Find Now.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"AA" <jgrace@.digitelusa.net> wrote in message
news:eKg1tz2VFHA.3540@.TK2MSFTNGP15.phx.gbl...
>i have a app that runs on sql. i need to fine a table in it to make
>changes. the table should have a field in it call translations patterns"
>in it. what the cmds for QA do i use and what else do i need to do to see
>whats this table tide to. Please help
> --
> James Grace
> System Engineer /Professional Srvc.
> MCSE MCSA MCDBA CCNA CCNP CQS
>
>
|||Hi,
You could also do a search in INFORMATION_SCHEMA.columns view.
SELECT COLUMN_NAME,TABLE_NAME
FROM INFORMATION_SCHEMA.columns
WHERE COLUMN_NAME like 'translations%'
You could also query syscolumns system table (Not recommended)
Thanks
Hari
SQL Server MVP
"AA" <jgrace@.digitelusa.net> wrote in message
news:eKg1tz2VFHA.3540@.TK2MSFTNGP15.phx.gbl...
>i have a app that runs on sql. i need to fine a table in it to make
>changes. the table should have a field in it call translations patterns"
>in it. what the cmds for QA do i use and what else do i need to do to see
>whats this table tide to. Please help
> --
> James Grace
> System Engineer /Professional Srvc.
> MCSE MCSA MCDBA CCNA CCNP CQS
>
>
|||Try AgileInfoSoftware's DataStudio, it has very powerful search features.
Evaluation is free and can be downloaded at http://www.AgileInfoLLC.com
John
Senior Support Engineer
MCSD, MCSD.NET, SCJP, SCJD, OCDBA
"AA" <jgrace@.digitelusa.net> wrote in message
news:eKg1tz2VFHA.3540@.TK2MSFTNGP15.phx.gbl...
>i have a app that runs on sql. i need to fine a table in it to make
>changes. the table should have a field in it call translations patterns"
>in it. what the cmds for QA do i use and what else do i need to do to see
>whats this table tide to. Please help
> --
> James Grace
> System Engineer /Professional Srvc.
> MCSE MCSA MCDBA CCNA CCNP CQS
>
>