Webmaster Forum Rules | Posting Guide | Contact Us | Testimonials | Contributing Geek Program | Advertise on Geek/Talk
Welcome to the GeekTalk Webmaster Discussion Forums from GeekVillage.com

Click Here To Register. It's Free!

Go Back   geek/talk: Signature-free discourse for serious web publishers > YOUR CREATION: Building & Maintaining A Web Site > Web Development - Programming / Coding
User Name
Password
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 02-15-2017, 07:01 AM   #1
beingchinmay
Registered User
 
Join Date: Jun 2015
Posts: 246
Thumbs up Define candidate key, alternate key, composite key.

A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys. A key formed by combining at least two or more columns is called composite key.







Growth on Height | Step Up Height Increaser | Growth on Height
beingchinmay is offline   Reply With Quote
Old 08-17-2017, 12:10 AM   #2
ketul
Registered User
 
Join Date: Aug 2014
Location: bangalore
Posts: 401
Default

Candidate keys are those keys which is candidate for primary key of a table. In simple words we can understand that such type of keys which full fill all the requirements of primary key which is not null and have unique records is a candidate for primary key. So thus type of key is known as candidate key

Primary keys are used to identify tables. There is only one primary key per table. In SQL Server when we create primary key to any table then a clustered index is automatically created to that column.

When we create keys on more than one column then that key is known as composite key. Like here we can take an example to understand this feature. I have a table Student which has two columns Sid and SrefNo and we make primary key on these two column. Then this key is known as composite key.
ketul is offline   Reply With Quote
Reply

Bookmarks

Tags
database, sql

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What's the difference between a primary key and a unique key in SQL? beingchinmay Web Development - Programming / Coding 1 08-17-2017 12:13 AM
MYSQL Primary Key ccole Web Development - Programming / Coding 3 11-26-2001 12:53 AM
Extracting a 3DES key from an IBM 4758 DaveUK geek/yak 0 11-09-2001 03:30 PM
Key Internet Journal Shuts Down hammer Making Money with CPC and/or CPM Programs 0 08-18-2001 08:36 AM
What is the Key to Getting Traffic to Message Boards? affiliateblunders Marketing Your Website Online 10 07-04-2000 11:45 PM

Please support our advertisers. They ensure our survival.

All times are GMT -5. The time now is 11:38 AM.


GeekVillage.com is copyright © 1998-2015 Curiosity Cave - Science gifts for clever kids. All rights reserved.
Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.