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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 need DISTINCT_KEYS equivalent in SQL SERVER

Author  Topic 

nakhan
Starting Member

2 Posts

Posted - 2010-03-15 : 07:54:06
Hi

We are porting our application to SQL SERVER

In Oracle We use DISTINCT_KEYS which is a part of ALL_INDEXS table which gives Number of distinct indexed values

we are looking for similar column in sql server

Is sys.sysindexs.keycnt same as DISTINCT_KEYS in Oracle?

from
nayeem khan
   

- Advertisement -