Interested to Buy Any Domain ? << Click Here >> for more details...
how to find number of columns in a table in sql server 2000
and 2005 also
- 7 Answers
- 14568 Views
- HCL, Virtusa, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Does sql server 2016 have ssms?
Describe in brief databases and sql server databases architecture.
What are scheduled tasks in sql server?
Tell me about pre-defined functions of sql?
What are sql servers used for?
Can we write trigger for view?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
When should you use an instead of trigger?
can SSRS reports Cache results?
Can we use where and having clause together?
What is a deadlock and what is a live lock?
Why normalization is used?
How do I determine how many instances of sql server are installed on a computer?
What is a rollup clause?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
