Types of Keys

A Key is a data item that exclusively identifies a record. In other words, key is a set of column(s) that is used to uniquely identify the record in a table. It is used to fetch or retrieve records / data-rows from data table according to the condition/requirement. Key provide several types of constraints like column can’t store duplicate values or null values. Keys are also used to generate relationship among different database tables or views. Types of Keys

  • Super Key

  • Minimal Super Key

  • Candidate Key

  • Primary Key

  • Unique Key

  • Alternate Key

  • Composite Key

  • Foreign Key

  • Natural Key

  • Surrogate Key


Featured Posts

Something Isn’t Working…

Refresh the page to try again.Error: 46af34c90d5742df90778f3c6a1fc69a
Recent Posts

Something Isn’t Working…

Refresh the page to try again.Error: 72a3302b836a4de9b0a2911845c32d1f
Archive
Search By Tags
No tags yet.
Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square
Our top of the line locks

Residential Locks

Key-Less Locks

DC Locks N Keys locks collection
Call Us Now