Answer Posted / nisith ranjan samal
Yes,you can create primary key without creating unique index.
Alter table table_name add constraint constraint_name primary key(colum_name) disable
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between inner join and natural join?
i have some prob lem to tell me about my self in interview first round ...
Is sql open source?
How do I start sql from command line?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is sql select statement?
How many tables can a sql database have?
Explain the update statement in sql
Which join condition can be specified using on clause?
Is crud a cuss word?
Why trigger is used in sql?
Does oracle roll back the transaction on an error?
What are all the different normalizations?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What are the basic sql commands?