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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to create Clustered Primary Key to table?

Question Posted / saravakumar

Answers were Sorted based on User's Feedback



How to create Clustered Primary Key to table?..

Answer / sarika jayadave

USE <DATABASE NAME>
GO
ALTER TABLE [SERVER NAME].[TABLE NAME]
ADD CONSTRAINT [PRIMARY KEY NAME]
PRIMARY KEY CLUSTERED
(
[ORDER BY FILED NAME] ASC
)

Is This Answer Correct ?    3 Yes 0 No

How to create Clustered Primary Key to table?..

Answer / saravakumar

USE [AdventureWorks]
GO
ALTER TABLE [Sales].[Individual]
ADD CONSTRAINT [PK_Individual_CustomerID]
PRIMARY KEY CLUSTERED
(
[CustomerID] ASC
)

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What are the events recorded in a transaction log?

0 Answers  

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

Can you pass expressions to function parameters?

0 Answers  

What is trigger in salesforce?

0 Answers  

What is dbcc?

0 Answers  

What is cube dimension? : sql server analysis services, ssas

0 Answers  

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

What number aggregate functions are accessible there in sql?

0 Answers  

Explain view in sql server?

0 Answers  

Explain steps of normalization?

0 Answers  

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,

For more SQL Server Interview Questions Click Here
Categories