What is a database fieldname?

A database stores information like names, address, dates of birth etc. When the database is being designed, headings for these things are create, to store the different parts. These are the fields. "Name" is a field, and it could have the fieldname "Name". The designer will often decide to break the name into a first name and a surname. In that case each field would need a different fieldname. They might use "Fname" and "Sname" for example. "DOB" is often used as the fieldname for the field to store Dates of Birth. When the designers are then working to do queries or other programming with the database, they will use the fieldnames to access the data.