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'

What are logical database components? : SQL Server Architecture

958

---

Why is replication required on the sql server?

1004

---

What purpose does the model database server?

1053

---

How to reaname table name without using sp_Rename in sql server..?

935

---

How to use values from other tables in update statements in ms sql server?

1037

---

How can i Relate Tables in SSIS

1032

---

plss anybody specify tha constrian management system in dbms

2077

---

What is the difference between getdate and sysdatetime?

940

---

What is query parameter in ssrs?

143

---

How to run sql server 2005 books online on your local system?

914

---

what is nonclustered index

889

---

What is the difference between a stored procedure and a user defined function?

970

---

What is difference between commit and rollback when used in transactions?

901

---

Describe different Processing Modes offered by SSRS?

232

---

Mention the different authentication modes in sql server.

955

---