Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Index exist

Author  Topic 

sasan_vm
Yak Posting Veteran

51 Posts

Posted - 2008-04-23 : 02:28:47
Hello,

How can find an column has index or not , using T-Sql ?

Kind Regards,
sasan.

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2008-04-23 : 05:03:55
Which version of SQL Server?

Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-23 : 05:32:42
sp_help {table name}


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2008-04-23 : 05:57:45
Well, I was going to post this if it was SQL 2005...

http://milambda.blogspot.com/2006_07_01_archive.html

Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

sasan_vm
Yak Posting Veteran

51 Posts

Posted - 2008-04-23 : 07:34:20
quote:
Originally posted by Peso

sp_help {table name}


E 12°55'05.25"
N 56°04'39.16"




Thank you.
Go to Top of Page
   

- Advertisement -