Interested to Buy Any Domain ? << Click Here >> for more details...
How to create Clustered Primary Key to table?
- 2 Answers
- 5039 Views
- I also Faced
- E-Mail Answers
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 are the recovery models for a database?
What is check constraint in sql server?
What are cursors in ms sql server?
What are “phantom rows”?
What is the meaning of sql server?
What is a full text index?
What is 'Join' and explain its various types.
what is raid and what are different types of raid configurations? : Sql server database administration
How to move database physical files in ms sql server?
How do you connect 100 files as a flat file sources in one package of SSIS?
SQL Server Architecture ?
sql server architecture ?
-
Oracle (3253) - 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)
