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
