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
- 14281 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
Is BCNF better than 2NF & 3NF? Why?
What are built in functions?
what are user defined datatypes? : Sql server database administration
Explain alternate key, candidate key and composite key in sql server?
What do you mean by SQL injection attack?
What are different types of statement?
What happens if we shrink log file in sql server?
How do you handle datasets larger than 50 gb?
What is partition in sql server?
What are the operating modes in which database mirroring runs?
What is #temp and @table variable in SQL server?
What is checkpoint in sql server?
what are cursors? : Sql server database administration
What is the purpose of floor function?
What is the ‘fillfactor’?
