how to create a primary key with out creating an index?
Answers were Sorted based on User's Feedback
Answer / bhargavi
Primary key creates an Index implicitly.....so Its not
possible to create a Pk without am index....
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / vinoth
ALTER TABLE EMP ADD CONSTRAINT EMP_PK PRIMARY KEY(EMPNO)
DISABLE;
Primary key constraint is created and no index is created
since the constraint is disabled initially.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / santanu
hi,
we can create pry key also by creating a sequence with NO
CYCLE option.
san
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / akshay
yes it possible using trigger
Create sequence S_Number
start with 1
increment by 1;
create trigger Pri_key before insert on table(C1)
for each row
Variable number(5);
begin
select sequence.nextvalue into Variable;
insert into table c1 value(variable);
end
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / anubha
The above trigger will give error of mutating table as in
this trigger you are doing dml operation on the triggering
table.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / priyankur
Unique constraint will always create non-clustered index on
column. so creation of Unique constraint is not the
solution. Yes, only sequence can create unique column but
that is not necessarily Primary key unless you treat it
likewise.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / benniyel gnanaraj
when u create a primary in the table the index is
implicitly create.index is not neccessary
Is This Answer Correct ? | 0 Yes | 1 No |
What is implicit cursor in pl sql?
What is sql*loader and what is it used for? : aql loader
can i call procedure in package
Can a varchar be a primary key?
I want to execute a piece of code before calling a procedure. How to achieve it?
What are its different types of dbms?
Does sql view stored data?
When do we create bitmap indexes
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can We write bulk collect statement in triggers?
I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?
What is mutating sql table?