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
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12168 Visits: 7444
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; They'll drag you down to their level and beat you with experience" ;-)
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)

Group: General Forum Members
Points: 213597 Visits: 41977
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
SSCertifiable
SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)

Group: General Forum Members
Points: 7852 Visits: 4000
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

-------------------
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
Ref.: http://www.adminarsenal.com/admin-arsenal-blog/powershell-how-to-write-your-first-powershell-script

"Operator! Give me the number for 911!" - Homer Simpson

"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 (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)SSC Guru (213K reputation)

Group: General Forum Members
Points: 213597 Visits: 41977
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
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25877 Visits: 12494
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