Prev: The number of columns for each row in a table value constructor must be the same.?
Next: getting property values of a fulltext catelog
From: mavrick_101 on 24 Mar 2010 10:51
Hi,

I'm trying to change collation on a column but I get an error that there is
an index on this column.

How can I get details about the index, so that I may drop it and recreate
after the collation change.

Thanks.
From: Bob Barrows on 24 Mar 2010 10:56
mavrick_101 wrote:
> Hi,
>
> I'm trying to change collation on a column but I get an error that
> there is an index on this column.
>
> How can I get details about the index, so that I may drop it and
> recreate after the collation change.
>
> Thanks.
exec sp_helpindex 'tablename'
--
HTH,
Bob Barrows


From: Uri Dimant on 24 Mar 2010 11:00
Take a look into
sys.indexes

sys.objects







"mavrick_101" <mavrick101(a)discussions.microsoft.com> wrote in message
news:3A3B649B-8144-499C-A4E8-E5949CECE4F7(a)microsoft.com...
> Hi,
>
> I'm trying to change collation on a column but I get an error that there
> is
> an index on this column.
>
> How can I get details about the index, so that I may drop it and recreate
> after the collation change.
>
> Thanks.


From: jgurgul on 24 Mar 2010 11:20
Hi,

SELECT * FROM sys.indexes
WHERE OBJECT_NAME(object_id) = 'sysdiagrams'

or

EXEC sp_help sysdiagrams

Jon

"mavrick_101" wrote:

> Hi,
>
> I'm trying to change collation on a column but I get an error that there is
> an index on this column.
>
> How can I get details about the index, so that I may drop it and recreate
> after the collation change.
>
> Thanks.
From: Tibor Karaszi on 24 Mar 2010 12:35
I use below. Beware that sp_helpindex doesn't tell you about included
columns...

http://www.karaszi.com/SQLServer/util_sp_indexinfo.asp


--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"mavrick_101" <mavrick101(a)discussions.microsoft.com> wrote in message
news:3A3B649B-8144-499C-A4E8-E5949CECE4F7(a)microsoft.com...
> Hi,
>
> I'm trying to change collation on a column but I get an error that there
> is
> an index on this column.
>
> How can I get details about the index, so that I may drop it and recreate
> after the collation change.
>
> Thanks.

 | 
Pages: 1
Prev: The number of columns for each row in a table value constructor must be the same.?
Next: getting property values of a fulltext catelog