how to create a primary key with out creating an index?
Answer Posted / 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 |
Post New Answer View All Answers
What is schema in sql?
What is the difference between left and left outer join?
What is the difference between an inner join and an outer join?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
How can a function retun more than one value in oracle with proper example?
What is pl sql commands?
Is it possible to pass parameters to triggers?
How does rowid help in running a query faster?
what is 'mysqladmin' in mysql? : Sql dba
What are the different sql languages?
What is function and procedure in pl sql?
Is pl sql useful?
What are procedures used for?
Why do we use view in sql?
How do I create a sql script?