|
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
Navigation:
[Reply to this message]
|