Posted by Erland Sommarskog on 08/25/05 00:48

Madhivanan (madhivanan2001@gmail.com) writes:
> Is this?
>
> Select * from information_schema.columns where table_name='yourTable'

Select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='yourTable'

This matter with a case-sensitive collation. And the names in
INFORMATION_SCHEMA is all in uppercase.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]