ADD INDEX in SQL server Mobile

new to MS SQL

please help.

How do you add an Index in SQL server Mobile ?

I tried

ALTER TABLE customers ADD INDEX (CUSTOMER_NAME)

did not work

ALTER TABLE customers ADD INDEX custname (CUSTOMER_NAME)

did not work

ALTER TABLE customers ADD custname INDEX (CUSTOMER_NAME)

did not work

is ADD INDEX supported in mobile?

is there a complete sql syntax reference for mobile?

BTW I'm using Sql Mobile query analyser directy on PDA

You can use the t-SQL query for 'CREATE INDEX'

The syntax is CREATE [UNIQUE] [NONCLUSTERED] INDEX index_name ON table_name (column_name [ASC|DESC][,…n])

Search for "CREATE INDEX (SQL Server Mobile)" on www.msdn2.microsoft.com.

Thanks

Pragya

|||

Fantastic!

It works.

I used normal sql command on pda, and works..

and I spent 2 hours on this with no results from MSDN,

where would I be without your help!

BTW there is no www in front of msdn2..the link won't work