sori ada yang kurang, yang bener gini
drop index idx_karyawan ;
--- Erwam Suaj <[EMAIL PROTECTED]> wrote:
>
> Index dalam database selalu unique.
> kalo create nya seperti ini :
> create unique index idx_karyawan on karyawan(nip)
> ;
>
> kalo mau dihapus index nya (drop) ;
> drop idx_karyawan ;
>
> gitu aje ...
>
> Erwansyah
>
> --- yazid <[EMAIL PROTECTED]> wrote:
> >
> >
> > ALTER TABLE "dba"."ovt_emp" DELETE DELETE PRIMARY
> > KEY;
> > ALTER TABLE "dba"."ovt_emp" ADD PRIMARY
> > KEY("ocb_emp_id","ocb_month")
> >
> > Query diatas adalah utk menghapus dan membuat
> > primary key di suatu
> > table,
> > 1. bagaimana query utk menghapus INDEX
> > 2. bagaimana query utk membuat INDEX
> >
> > db: sqlanywhere
> > app: pb65
> >
> > thanks
> > Yazid
> >
> >
> >
> >
> >
> > -----------------------------------------------
> > INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
> > -----------------------------------------------
> > IndoPB - Indonesia PB User Group
> > To Post a message, send it to: [EMAIL PROTECTED]
> > To Unsubscribe,send a blank message to:
> > [EMAIL PROTECTED]
> > Yahoo! Groups Links
> >
> >
> > [EMAIL PROTECTED]
> >
> >
> >
> >
> >
> >
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/
>
>
> -----------------------------------------------
> INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
> -----------------------------------------------
> IndoPB - Indonesia PB User Group
> To Post a message, send it to: [EMAIL PROTECTED]
> To Unsubscribe,send a blank message to:
> [EMAIL PROTECTED]
> Yahoo! Groups Links
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
-----------------------------------------------
INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
-----------------------------------------------
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
