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 b tree index?

857

---

How many columns can we include on clustered index ?

923

---

How to define and use table alias names in ms sql server?

1042

---

What are commit and rollback in sql?

1052

---

Will count(column) include columns with null values in its count?

1033

---

What is difference between view and materialized view?

889

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

6796

---

What is the purpose of self join?

914

---

Define primary key?

1077

---

What are pages and extents? : SQL Server Architecture

956

---

What are the types of subscriptions in SQL Server replication?

961

---

Describe and explain about SQL native client?

1038

---

tell me the disaster recovery plan

2456

---

What is code near application topology?

271

---

Do you know what are various aggregate functions that are available?

1015

---