Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is schema in sql?

941


What is the difference between left and left outer join?

944


What is the difference between an inner join and an outer join?

1014


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1090


How can a function retun more than one value in oracle with proper example?

1070


What is pl sql commands?

1038


Is it possible to pass parameters to triggers?

1097


How does rowid help in running a query faster?

1411


what is 'mysqladmin' in mysql? : Sql dba

1021


What are the different sql languages?

1031


What is function and procedure in pl sql?

1034


Is pl sql useful?

983


What are procedures used for?

982


Why do we use view in sql?

944


How do I create a sql script?

1094