Re: How to rename index?

Article View: comp.databases.ms-access

Article #275

Back to comp.databases.ms-access Previous Next

#275

From: 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
>
>
>
>
>
>

Technical Details

Message-ID: <3c95e3eb$1@news.grutzeck.local>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!supernews.com!freenix!deine.net!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp02!news.grutzeck.local

References: <3c9210d9$1@news.grutzeck.local> <a74ff6$a6d$1@talia.mad.ttd.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 111a5a,d64d376465fadf4
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1041a7,d64d376465fadf4
X-Google-Attributes: gid1041a7,public
X-Google-Thread: 103569,d64d376465fadf4
X-Google-Attributes: gid103569,public
X-Google-Thread: ff0ac,d64d376465fadf4
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1143a6,d64d376465fadf4
X-Google-Attributes: gid1143a6,public
X-Google-Thread: 101bdd,d64d376465fadf4
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 109305,d64d376465fadf4
X-Google-Attributes: gid109305,public
X-Google-ArrivalTime: 2002-03-18 05:25:09 PST
From: "Plamen Petrov" <plamen.petrov@grutzeck.de>
References: <3c9210d9$1@news.grutzeck.local> <a74ff6$a6d$1@talia.mad.ttd.net>
Subject: Re: How to rename index?
Date: Mon, 18 Mar 2002 13:56:10 +0100
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Original-NNTP-Posting-Host: 192.18.4.172
Message-ID: <3c95e3eb$1@news.grutzeck.local>
X-Original-Trace: 18 Mar 2002 13:56:11 +0100, 192.18.4.172
Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,microsoft.public.access.dataaccess.pages,microsoft.public.access.forms,microsoft.public.access.tablesdbdesign,microsoft.public.data.oledb,microsoft.public.office.access.devtoolkits
NNTP-Posting-Host: p5080c5a2.dip0.t-ipconnect.de 80.128.197.162
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!supernews.com!freenix!deine.net!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp02!news.grutzeck.local

Reply to Parent Message