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 lazy writer?
wat wil hapn if we give the both read and deny read permission to user?
What is a filestream?
How you can get a list of all the table constraints in a database? : Sql server administration
When cursors are useful?
How to find out the list schema name and table name for the database?
What do you understand by mirroring?
What are the two virtual tables SQL Server maintains for triggers?
what is the difference between openrowset and openquery?
How to name query output columns in ms sql server?
Diffrent types of function
What is the function of sql server agent windows service?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)