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 sqlserverThe systable is in the master database. I hope the user you are connecting
through has permission to access the master database.
In case the user does have permission you will be able to query... find a
sample query below
select * from master.dbo.syscolumns
"joy.net" wrote:

> hi
> iam a csharp developer . the problem is i don't know how to select in
> systables of sqlserver
>
>|||sysDatabases is in Master, syscolumns, sysobjects only gives you the
tables,indexes etc that are contained in master, it does not give a 'global'
view of every table.
If you want the columns, tables, indexes for the current database you need
to use the system objects in that database.
select * from TargetDatabase..sysobjects where xtype = 'u'
"Karthik" <Karthik@.discussions.microsoft.com> wrote in message
news:F74BF6BD-22F0-41A5-97D8-35775813157E@.microsoft.com...
> The systable is in the master database. I hope the user you are connecting
> through has permission to access the master database.
> In case the user does have permission you will be able to query... find a
> sample query below
> select * from master.dbo.syscolumns
> "joy.net" wrote:
>