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 the main reason behind using an index?
What is the primary key?
What is PL/SQL table ?
What does partition by mean in sql?
What are local and global variables and their differences?
What steps server process has to take to execute an update statement?
What is an alias command?
What is mutating table?
after tell procedure whole code he asked can i write the same way in a function
What is dense_rank in sql?
Define overloaded procedure?
What do you understand by pl/sql packages?