Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have permission to ask a question, You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

Ask The Science

Ask The Science Logo Ask The Science Logo

Ask The Science Navigation

  • Home
  • Blog
  • About Us
  • Contact Us
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • About Us
  • Contact Us
Home/ Questions/Q 990
Next
Answered
Ask The Science
  • 0
Ask The Science
Asked: December 18, 20222022-12-18T01:00:51+05:30 2022-12-18T01:00:51+05:30

What is a surrogate key?

  • 0

What is a surrogate key?

interview questionssql interview questions
  • 1 1 Answer
  • 17 Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook

    1 Answer

    • Voted
    • Oldest
    • Recent
    1. Best Answer
      Ask The Science
      2022-12-18T01:01:11+05:30Added an answer on December 18, 2022 at 1:01 am

      A surrogate key is a field in a table that has been created solely for the purpose of being the primary key. It has no other purpose than internal storage and reference number.

      For example, a customer may have an account number that is unique to them, but a customer_id field might be created on the table and used as the primary key, in case business rules change and mean that the account number is no longer unique.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp

    You must login to add an answer.

    Forgot Password?

    Need An Account, Sign Up Here

    Sidebar

    Ask A Question

    Related Questions

    • If a table contains duplicate rows, will a query display ...

    • What is a synonym?

    • What is a unique constraint? How is it different from ...

    • What is a composite key?

    • What is a foreign key?

    • Popular
    • Answers
    • BigB

      Why do we not fall off from the Earth?

      • 2 Answers
    • KSR

      What is the difference between von Neumann architecture and Harvard ...

      • 1 Answer
    • BigB

      What is the external structure of the Earth?

      • 1 Answer
    • BigB

      What is the internal structure of the Earth?

      • 1 Answer
    • BigB

      How do we discover what is inside the Earth?

      • 1 Answer
    • KSR
      KSR added an answer VON NEUMANN ARCHITECTURE It is an ancient computer architecture based… December 26, 2022 at 5:38 pm
    • Ask The Science
      Ask The Science added an answer Yes, they will be displayed by default. To eliminate duplicate… December 18, 2022 at 1:05 am
    • Ask The Science
      Ask The Science added an answer A synonym is a database object that allows you to… December 18, 2022 at 1:04 am
    • Ask The Science
      Ask The Science added an answer A unique constraint is a constraint on a table that… December 18, 2022 at 1:02 am
    • Ask The Science
      Ask The Science added an answer A surrogate key is a field in a table that… December 18, 2022 at 1:01 am

    Trending Tags

    advantages of linked list circular singly list c program data engineer interview questions data structure data structure interview questions data structure interview questions and answers data structures front end front end interview questions heterogeneous linked list interview questions linked list linked lists python python interview questions queue queue data structure software testing interview questions sql interview questions syntax

    Explore

    • Recent Questions
    • Most Answered
    • Answers
    • No Answers
    • Most Visited
    • Most Voted
    • Random

    Footer

    Ask the Science

    Ask the Science is a Science questions & Answers Engine which will help you establish your community and connect with other people.

    Legal

    • Privacy Policy
    • Terms and Conditions

    About Us

    • About Us
    • Blog
    • Contact Us

    © 2022, All Rights Reserved
    With Love by Ask The Science.