|
|
|
Junior Member
 
Group: Forum Members
Last Login: 8/22/2008 11:30:56 AM
Posts: 22,
Visits: 41
|
|
Hi
select * from DBC.Columns where ColumnName = 'ACC_NO'
The above query results with the System tables also ....
but i need only the user tables .......
Can u pls suggest me the way to do it.
Regards
Dileep
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/26/2008 7:30:15 AM
Posts: 1,
Visits: 4
|
|
Hi Dileep !
You have to join to DBC.DataBases to get the information wether it is a System or User-DB.
SELECT *
FROM DBC.Columns AS C
INNER JOIN DBC.DataBases AS D ON (C.DataBaseName = D.DataBaseName)
WHERE
(
(D.DataBaseName NOT IN ('DBC', 'CrashDumps')) AND
-- UserDataBase
(D.DBKind = 'U') AND
(C.ColumnName LIKE '%test%')
);
Regards
Robert
|
|
|
|