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 the most common sql injection tool?

1027


What is recursive join in sql?

984


Is not equal in sql?

996


how do you know the version of your mysql server? : Sql dba

986


How can you create an empty table from an existing table?

1057


Which is better varchar or nvarchar?

977


What is the source code of a program?

1046


How do you write a complex sql query?

1044


What is the cause of mutating table error and how can we solve it?

1036


What is nosql vs sql?

1157


How delete a row in sql?

974


Explain about various levels of constraint.

921


How is pl sql different from sql?

1060


In what condition is it good to disable a trigger?

995


What is pl sql commands?

1024