i am working with a new database which is already designed.it is very large and difficult to understand. my problem is...
can i find a perticular column in the table where it exists?
to find emp_id column in the database which contains all the tables.
Originally posted by Bart71
select * from all_tab_columns where column_name = 'EMP_ID';
i need to contact you once again. the following query runs under ORACLE. but now i need the same resulted query which runs on SQLServer. will you please help me. once again thanks for sending the ORACLE query. waiting for your reply.