Anyone can tell me the fast way to find out which columns
of the tables are indexed? Thanks.
Either query sysindexes and sysindexkeys. Or use sp_helpindex.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bill" <fei0405@.yahoo.com> wrote in message news:019301c49b46$23315c70$a301280a@.phx.gbl...
> Anyone can tell me the fast way to find out which columns
> of the tables are indexed? Thanks.
Showing posts with label columnsof. Show all posts
Showing posts with label columnsof. Show all posts
Sunday, February 19, 2012
Subscribe to:
Posts (Atom)