Default Values - Database
Definition - What does Default Values - Database mean?
Default values, in the context of databases, are preset values defined for a column type. Default values are used when many records hold similar data.
Techopedia explains Default Values - Database
When creating a database table in systems such as Oracle or SQL Server, an option to specify a default value is available. This separates database design issues from the front-end application. For instance, if a bank's interest rate for the current financial year is 8 percent, this may be set as the default value. This relieves the user from having to enter it repeatedly into the database. Most databases use the keyword “default” as a data type.
Modification to a default data type can be changed by using the ALTER TABLE command. When a new row is created with vacant column data type, it is filled with default values. For example, the “Date” column in most cases has a default data type as the “CURRENT DATE.”
-
The 4th Era of IT Infrastructure - Superconverged Systems - Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th generation of IT infrastructure – superconverged – can transform your business.
Email Newsletter
Join thousands of others with our weekly newsletter
Please Wait...
Resources
![[DON'T MISS] Optimal Forecasting: Save Time, Money and Trouble](http://cdn.techopedia.com/resource/images/qrcode.png?width=80&height=40)
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.
