Interested to Buy Any Domain ? << Click Here >> for more details...
how to create a primary key with out creating an index?
- 9 Answers
- 20620 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
Is time a data type in sql?
How to write pl sql program in mysql command prompt?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Does view contain data?
What is user in sql?
Is sql better than excel?
Why do we use procedures?
How do I save a stored procedure?
Who is the owner of mysql database?
What is substitution variable in pl sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is data type in database?
What is compound trigger?
What is sql dialect?
What is indexes?
