开发者

how to create unique keyword in the oracle db?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜