TSQL solution to determine if an index exists on SQL Mobile.

[Peager]

I have an application running on SQL Mobile (or lite or whatever it's called these days).

What I need to do is run an SQL query that will tell me if an index has been defined on a particular table.

I know I can do this with SQL Enterprise but how is it done on SQL Mobile?

Much thanks in advance.

Paul

 

[gmmastros]

I don't know anything about SQL Mobile, but to determine the indexes on a table using T-SQL, you would run the following command:

sp_helpindex 'YourTableNameHere'

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Peager]

George

Thanks for your response. I already know that trick. The problem is that I need to know programatically if a particular index exists so I can create it if it doesn't. There has to be some query that can be run giving the table and/or index name that would return a yes/no response. I'm just not up to speed on SQL CE.

Thanks again for your time.

Paul

 

[markros]

Have you checked answers in your thread in MSDN on this topic?

MSDN Thread

PluralSight Learning Library