How to rename index?

Thread View: comp.databases.ms-access

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Plamen Petrov Fri, 15 Mar 2002 15:18

#276

Author: Plamen Petrov
Date: Fri, 15 Mar 2002 15:18

9 lines
1897 bytes

Hi Group,

    Is it possible an index into MS Access databases to be renamed by OLEDB
interface or by DDL command?
In MS SQL Server this is possible by the SP sp_rename. Is there in Jet an
analog to sp_rename?

Thanks,
Plamen Petrov

RE: How to rename index?

#274

Author: Gomzky
Date: Mon, 18 Mar 2002 10:32

19 lines
2153 bytes

Privet Petrov!
It's not possible rename an index in Jet Databases.- You must delete and
create it again with new name.- Use CREATE INDEX Command for do it;

Regards.-
Gomzky
___________

Plamen Petrov <plamen.petrov@grutzeck.de> escribi� en el mensaje de noticias
3c9210d9$1@news.grutzeck.local...
Hi Group,

    Is it possible an index into MS Access databases to be renamed by OLEDB
interface or by DDL command?
In MS SQL Server this is possible by the SP sp_rename. Is there in Jet an
analog to sp_rename?

Thanks,
Plamen Petrov

Re: How to rename index?

#275

Author: Plamen Petrov
Date: Mon, 18 Mar 2002 12:56

40 lines
2651 bytes

Thanks, you saved me a lot of time.

    Do you know is it possible to rename a table column in Jet database?
    IAlterTable::AlterColumn sounds like to be able, but I can't see such
    a property - there are flags about change datatype, precision, ID !!!
    But nothing about the name.

Plamen Petrov



"Gomzky" <Gomzky@hotmail.com> wrote in message
news:a74ff6$a6d$1@talia.mad.ttd.net...
> Privet Petrov!
> It's not possible rename an index in Jet Databases.- You must delete and
> create it again with new name.- Use CREATE INDEX Command for do it;
>
> Regards.-
> Gomzky
> ___________
>
> Plamen Petrov <plamen.petrov@grutzeck.de> escribi� en el mensaje de
noticias
> 3c9210d9$1@news.grutzeck.local...
> Hi Group,
>
>     Is it possible an index into MS Access databases to be renamed by
OLEDB
> interface or by DDL command?
> In MS SQL Server this is possible by the SP sp_rename. Is there in Jet an
> analog to sp_rename?
>
> Thanks,
> Plamen Petrov
>
>
>
>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads