On-Line Next application. Transaction Logs are also created on one or more devices. Tables are sets of related information stored within the database. In older systems those which do not use this approach to storage tables are the equivalent of the physical files on disk one table per file. In dBase for example the equivalent is a single database file on disk which relates to one table within a database.
Columns are individual pieces of information traditionally referred to as fields.
If you think of a table as a spreadsheet you'll have a good idea of how it is laid out. Rows are sets of columns and there is one row per record in more traditional non-SQL terms. Again if you think of a spreadsheet metaphor this makes a good deal of sense. In this chapter you find out how to create the tables and the components of the table the row and column. As with other database systems each column can have a specific datatype associated with it and each datatype has certain CHARacteristics.