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 a primary key? : Sql dba
How does index help in query performance?
What is the difference between local variables and global variables?
What is prepared statement in sql?
what is the difference between a having clause and a where clause? : Sql dba
How do you update a value in sql?
Are stored procedures faster than queries?
What is the difference between a query and a report?
Is it mandatory for the primary key to be given a value when a new record is inserted?
how to select unique records from a table? : Sql dba
How do you create a db file?
How exception is different from error?
Can we perform dml in function?
What is a temporal table?
What is the difference between functions, procedures, and packages in pl/sql?