Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bobby
select * from information_schema.columns where
column_name='orderid'
The above query is used to find all the tables and views in
the Database which contain ‘orderId’ as column name.
But to find only the tables in the Database which
contain ‘orderId’ as column name, use the below query.
select col.table_name from information_schema.columns Col
join information_schema.tables Tab
on col.table_name=tab.table_name and
col.column_name='orderId'and tab.table_type='Base Table'
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Does any body please help me what question's have asked for SSRS in the interview?
Explain atomicity?
Explain multiserver query
Define candidate key, alternate key, and composite key.
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What do you understand by physical_only option in dbcc checkdb?
Which are the important points to note when multilanguage data is stored in a table?
What is best institute to Learn DotNET And SQL in chennai?
What do we need queues in sql service broker?
How to integrate the ssrs reports in application?
Mention the command used to rename the database.
Explain how you can deploy an SSRS report?
What is the sql case statement used for?
Explain sub-query?
What is join query?
