开发者

how to create unique keyword in the oracle db?

开发者 https://www.devze.com 2022-12-26 14:32 出处:网络
i am using autocomplete with oracle Db,how to create unique keyword for the table. KEYWORDVARCHAR2(100)

i am using autocomplete with oracle Db,how to create unique keyword for the table.

KEYWORD VARCHAR2(100) COUNT 开发者_StackOverflow中文版 NUMBER(18)

how can i make as unique

can plz tell the query


ALTER TABLE mytable add CONSTRAINT keyword_unique UNIQUE (keyword);


create table "unique keyword" ("KEYWORD" VARCHAR2(100), "COUNT" NUMBER(18));

I think that will do the trick ;-)

0

精彩评论

暂无评论...
验证码 换一张
取 消