How to find field exists in which table +sql server
Hi,
I know the field exists in databse but,need to know in which table.
Any suggestions are appreciated.
Cheers
I know the field exists in databse but,need to know in which table.
Any suggestions are appreciated.
Cheers
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
alternative way :-
select TABLE_NAME from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='your_column_name'
ASKER