how to know a column was indexed or not ?

hi
iam a csharp developer . the problem is i don't know how to select in
systables of sqlserverHi Joy
Just check this query:
SELECT i.name, o.name
FROM dbo.sysindexes i
INNER JOIN dbo.sysobjects o
ON i.id = o.id
WHERE indid > 0 AND indid < 255 AND o.type = 'U'
this might help you.
Please let me know if you have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.SQLResource.com/
---
"joy.net" wrote:

> hi
> iam a csharp developer . the problem is i don't know how to select in
> systables of sqlserver
>
>
>