How to create Clustered Primary Key to table?
Answers were Sorted based on User's Feedback
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 |
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 |
What is a rollup clause?
What is the difference between value type and reference type?
How can you list all the columns in a database?
What is extent? Types of extents?
What is data source document?
How can you get @@error and @@rowcount at the same time?
what is nonclustered index
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Can we use where clause with group by?
What is use of @@ spid in sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is default port number for sql server 2000?