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 the most common sql injection tool?
What is recursive join in sql?
Is not equal in sql?
how do you know the version of your mysql server? : Sql dba
How can you create an empty table from an existing table?
Which is better varchar or nvarchar?
What is the source code of a program?
How do you write a complex sql query?
What is the cause of mutating table error and how can we solve it?
What is nosql vs sql?
How delete a row in sql?
Explain about various levels of constraint.
How is pl sql different from sql?
In what condition is it good to disable a trigger?
What is pl sql commands?