|
1994.5.8
by Stewart Smith
fix up spinx syntax |
1 |
Tables
|
2 |
======
|
|
|
1945.3.3
by Marisa Plumb
updates to a few sql docs |
3 |
|
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
4 |
A table makes up a collection of :doc:`/columntypes` that |
5 |
can be joined together in order to create relational result sets. |
|
6 |
||
7 |
Each record in the table is called a row, and a table can have an infinite |
|
|
1945.3.4
by Marisa Plumb
SQL edits and rewrites |
8 |
set of rows. Each row represents one piece of data, and each column can |
|
1945.3.8
by Marisa Plumb
fixes to some rst markup |
9 |
be thought of as representing a component of that piece of data. |
10 |
||
11 |
So, for example, if we have a table for a customer information, then |
|
|
1945.3.4
by Marisa Plumb
SQL edits and rewrites |
12 |
the columns may include information such as First Name, Last Name, |
13 |
Address, City, Country, Birth Date, and so on. As a result, tables have |
|
14 |
column headers, which specify the data types for that particular column. |
|
|
1945.3.3
by Marisa Plumb
updates to a few sql docs |
15 |
|
|
1945.3.9
by Marisa Plumb
changes in cross-references |
16 |
.. toctree:: |
17 |
:maxdepth: 2 |
|
|
1945.3.3
by Marisa Plumb
updates to a few sql docs |
18 |
|
|
1945.3.9
by Marisa Plumb
changes in cross-references |
19 |
alter_table |
20 |
create_table |
|
21 |
drop_table |
|
22 |
truncate |
|
23 |
rename |