SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Most Basic SQL Doubt - Why is it called a Table in the first place?


Most Basic SQL Doubt - Why is it called a Table in the first place?

Author
Message
arun11.prasanth
arun11.prasanth
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 6
Hi
I have been pondering this for a while now. All the rest of SQL objects (Views, Procs, Triggers, Indexes) have suitable names that pertain to the meaning of the same. But why is a database Table called a 'Table' in the first place?
Does a real-world table contain rows and columns? Why did they name it thus?

I'm sure this question might seem silly for many. But I had this doubt ever since I heard of SQL tables and would like to know the reason why they're named that way.
MyDoggieJessie
MyDoggieJessie
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26892 Visits: 7488
The best answer I can give you is, Latin - "Table" is derived from the classical Latin word "tabula."

Maybe it got its name because it's a structure that you can place things on, stack neatly, easily organize...and all the other good words in the language were taken already!

That's like questioning why the letters of the alphabet start with "A-B-C" and not Q-W-E" :-D
(Snort, snort, snort)

______________________________________________________________________________
Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)

Group: General Forum Members
Points: 508645 Visits: 44285
It comes from the second definition for "Table" in the dictionary...

a set of facts or figures systematically displayed, esp. in columns.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
webrunner
webrunner
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16822 Visits: 4141
I think this is the most complete etymological explanation:

http://english.stackexchange.com/questions/10976/does-the-word-table-have-anything-to-do-with-a-table

That kind of table comes from the Latin tabula meaning "a board or plank" which was used for writing down columns of numbers


That page has a link to this page, which has further detail:
http://www.etymonline.com/index.php?search=table&searchmode=none

Both the French and Germanic words are from Latin tabula "a board, plank; writing table; list, schedule; picture, painted panel," originally "small flat slab or piece" usually for inscriptions or for games (source also of Spanish tabla, Italian tavola), of uncertain origin, related to Umbrian tafle "on the board."


Basically, it seems like boards and planks were sometimes used to record lists or other data, and eventually that idea stuck in the derived name.

I hope this helps.

Great question, by the way!

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and says Can I join you?
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)SSC Guru (508K reputation)

Group: General Forum Members
Points: 508645 Visits: 44285
webrunner (5/24/2014)
I think this is the most complete etymological explanation:

http://english.stackexchange.com/questions/10976/does-the-word-table-have-anything-to-do-with-a-table

That kind of table comes from the Latin tabula meaning "a board or plank" which was used for writing down columns of numbers


That page has a link to this page, which has further detail:
http://www.etymonline.com/index.php?search=table&searchmode=none

BWAA-HAAAA!!! I was just thinking that I should change the article called "Crosstabs and Pivots" to "Crossed Planks and Hinges". :-P

Both the French and Germanic words are from Latin tabula "a board, plank; writing table; list, schedule; picture, painted panel," originally "small flat slab or piece" usually for inscriptions or for games (source also of Spanish tabla, Italian tavola), of uncertain origin, related to Umbrian tafle "on the board."


Basically, it seems like boards and planks were sometimes used to record lists or other data, and eventually that idea stuck in the derived name.

I hope this helps.

Great question, by the way!

- webrunner


--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Tom Thomson
Tom Thomson
SSC Guru
SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)SSC Guru (50K reputation)

Group: General Forum Members
Points: 50766 Visits: 13159
Even today the Latin word tabula is sometimes used in English, for example in the phrase "tabula rasa" (an erased slate - or an empty table :-D); in Latin, it meant a slate or a wax tablet, the two common things on which one could write or draw and also erase or alter what was already there. And that's where English got the word table from.

So one meaning of "table" is something that can record information and whose contents can be deleted or altered. One special meaning was for such a thing where the information was organised into rows and columns. This special meaning antedated relational databases by a very long time, and given what the storage structure in relational databases is it's not surprising that people noticed that the storage structure consisted of something for which we already had the name "table" and didn't bother to invent a new name.

Tom

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search