Article View: comp.databases.ms-access
Article #274RE: How to rename index?
From: Gomzky
Date: Mon, 18 Mar 2002 10:32
Date: Mon, 18 Mar 2002 10:32
19 lines
2153 bytes
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
Technical Details
Message-ID:
<a74ff6$a6d$1@talia.mad.ttd.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!62.24.128.9.MISMATCH!news-1.opaltelecom.net!lon1-news.nildram.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.cwix.com!newsfeed.bcn.ttd.net!news.mad.ttd.net!not-for-mailReferences:
<3c9210d9$1@news.grutzeck.local>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: 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-Thread: ff0ac,d64d376465fadf4 X-Google-Attributes: gidff0ac,public X-Google-ArrivalTime: 2002-03-18 02:28:35 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!62.24.128.9.MISMATCH!news-1.opaltelecom.net!lon1-news.nildram.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.cwix.com!newsfeed.bcn.ttd.net!news.mad.ttd.net!not-for-mail From: "Gomzky" <Gomzky@hotmail.com> 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 Subject: RE: How to rename index? Date: Mon, 18 Mar 2002 11:32:39 +0100 Organization: Telefonica Transmision de Datos Lines: 25 Message-ID: <a74ff6$a6d$1@talia.mad.ttd.net> References: <3c9210d9$1@news.grutzeck.local> NNTP-Posting-Host: 213-98-46-180.uc.nombres.ttd.es X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200