Columns in Firebird - Firebird

Data in a relational database system such as Firebird is arranged logically in sets consisting of rows and columns. A column holds one piece of data with defining attributes that are identical for every row in the set. A column definition has two required attributes: an identifier (or column name) and a data type. Certain other attributes can be included in a column definition, such as a CHARACTER SET and constraints like NOT NULL and UNIQUE.

Sets that are defined for storing data are known as tables. The row structure of a table is defined by declaring a table identifier and listing the column identifiers, their data types, and any other attributes needed, on a column-by-column basis.

A simple example of a table definition is

CREATE TABLE SIMPLE ( COLUMN1 INTEGER, COLUMN2 CHAR(3), COLUMN3 DATE);

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Firebird Topics