how to create a primary key with out creating an index?
- 9 Answers
- 18845 Views
- TCS, I also Faced
- E-Mail Answers
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 are all the different normalizations? : Sql dba
what is the difference between delete and truncate statement in sql? : Sql dba
Is inner join same as self join?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is aggregate function in sql?
How do I count rows in sql query?
What steps server process has to take to execute an update statement?
how to show all tables with 'mysql'? : Sql dba
What is procedure in pl sql?
What found sql?
What is cross join example?
what's the difference between a primary key and a unique key? : Sql dba
How much does a sql dba make? : SQL DBA
What are the types of queries in sql?
Can we debug stored procedure?
