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
<*> 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/
