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 are the sql versions?
What is cold data?
Can you selectively load only those records that you need? : aql loader
What is trigger in sql and its types?
How is a process of pl/sql compiled?
how to enter numeric values as hex numbers? : Sql dba
Is trigger a stored procedure?
Which table is left in left join?
Is it possible to read/write files to-and-from PL/SQL?
what is the syntax for using sql_variant_property? : Transact sql
Why do we use view in sql?
How do I view output in sql developer?
Why we use cross join?
What is sql not null constraint?
What is parallel hint?