Answer Posted / anuruddha

SELECT
K_Table = FK.TABLE_NAME,
FK_Column = CU.COLUMN_NAME,
PK_Table = PK.TABLE_NAME,
PK_Column = PT.COLUMN_NAME,
Constraint_Name = C.CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON
C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON
C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON
C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
INNER JOIN (
SELECT i1.TABLE_NAME, i2.COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON
i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME
WHERE i1.CONSTRAINT_TYPE = 'PRIMARY KEY'
) PT ON PT.TABLE_NAME = PK.TABLE_NAME

What is the difference between resultset and resultsetmetadata?

981

---

Does a full backup include transaction log?

981

---

Is it possible to have clustered index on separate drive from original table location?

970

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

994

---

How do you create an execution plan?

954

---

What is the purpose of sql profiler in sql server?

1027

---

Explain tables in SQL Azure?

120

---

What is use of except clause? How does it differ from not in clause?

1022

---

How to test a dml trigger in ms sql server?

1053

---

Can you use order by when defining a view?

980

---

Why people hate cursor?

1151

---

How can you know if the row fetched from cursor is still valid in underlying table?

1001

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1058

---

Can you index views?

899

---

What are different types of statement?

1022

---