테이블 (데이터베이스)

관계형 데이터베이스와 플랫 파일 데이터베이스에서 테이블(table)은 세로줄과 가로줄의 모델을 이용하여 정렬된 데이터 집합(값)의 모임이다.

테이블 내의 데이터는 물리적으로 데이터베이스에 저장되지는 않는다. 뷰 또한 관계형 테이블이지만 이들의 데이터는 쿼리 시간에 계산된다. 다른 예로 별명(nickname)이 있는데 이는 다른 데이터베이스의 표를 가리키는 포인터를 나타낸다.

종류

  • 관계형 테이블: 관계형 데이터베이스의 사용자 데이터를 보유하는 기본 구조.
  • 오브젝트 테이블: 세로줄을 정의하는 객체 형을 이용하는 테이블. 정의된 형의 오브젝트의 인스턴스를 보유할 목적으로 정의된다.

SQL에서는 CREATE TABLE 문을 이용하여 이러한 테이블을 만든다.[1]

같이 보기

각주

  1. ↑ Diana Lorentz and Joan Gregoire (Primary Authors) (December 2003). 〈CREATE TABLE〉. 《Oracle Database SQL Reference 10g Release 1 (10.1)》. Oracle Corporation. Part Number B10759-01. 2011년 12월 8일에 원본 문서에서 보존된 문서. 2011년 11월 15일에 확인함. 
이 글은 소프트웨어에 관한 토막글입니다. 여러분의 지식으로 알차게 문서를 완성해 갑시다.

Read other articles:

Dôme de Genbaku

Mémorial de la paix de Hiroshima (dôme de Genbaku) *  Patrimoine mondial de l'UNESCO Le dôme de Genbaku. Coordonnées 34° 23′ 44″ nord, 132° 27′ 13″ est Pays Japon Type Culturel Critères (vi) Numérod’identification 775 Région Asie et Pacifique ** Année d’inscription 1996 (20e session) * Descriptif officiel UNESCO** Classification UNESCO modifier  Le dôme de Genbaku ou dôme de la bombe atomique (原爆ドーム, Genbaku ...

 

كلاوديو إستودور

هذه المقالة يتيمة إذ تصل إليها مقالات أخرى قليلة جدًا. فضلًا، ساعد بإضافة وصلة إليها في مقالات متعلقة بها. (يناير 2020) كلاوديو إستودور معلومات شخصية الميلاد 5 سبتمبر 1960 (63 سنة)[1]  تيميشوارا  مواطنة رومانيا  الأولاد تيودور إستودور  الحياة العملية المدرسة الأم جامع

 

Olof Mellberg

Olof Mellberg Informasi pribadiNama lengkap Erik Olof MellbergTanggal lahir 3 September 1977 (umur 46)Tempat lahir Gullspång, SwediaTinggi 187 m (614 ft)Posisi bermain BekInformasi klubKlub saat ini Villarreal CFNomor 6Karier junior1994–1996 Gullspångs IFKarier senior*Tahun Tim Tampil (Gol)1996–1997 Degerfors IF 47 (0)1998 AIK 17 (0)1998–2001 Racing Santander 98 (0)2001–2008 Aston Villa 232 (8)2008–2009 Juventus 27 (2)2009–2012 Olympiacos 71 (7)2012– Villarreal ...

Piazza dell'Indipendenza (Firenze)

Piazza dell'IndipendenzaAltri nomiPiazza Indipendenza Nomi precedentiPiazza Maria Antonia, piazza di Barbano LocalizzazioneStato Italia CittàFirenze Circoscrizionequartiere 1 QuartiereSan Lorenzo Codice postale50129 Informazioni generaliTipopiazza Mappa Modifica dati su Wikidata · ManualeCoordinate: 43°46′47.34″N 11°15′13.68″E / 43.779817°N 11.2538°E43.779817; 11.2538 Piazza dell'Indipendenza, già piazza di Barbano, è una grande piazza del centro stor...

 

Hochschule für angewandte Wissenschaften Weihenstephan-Triesdorf

Hochschule für angewandte Wissenschaften Weihenstephan-Triesdorf Gründung 1971 Trägerschaft staatlich Ort Freising und Triesdorf Bundesland Bayern Bayern Land Deutschland Deutschland Präsident Eric Veulliet Studierende 6.350 WS 2016/17 Mitarbeiter 652 davon Professoren 146 Professoren, 268 Lehrbeauftragte Website www.hswt.de Übersicht über die Hochschulanlage auf dem Campus Freising-Weihenstephan Erläuterung zur Übersicht Die Hochschule für angewandte Wissenschaften Weihens...

 

الزيل (السياني)

الزيل (محلة) تقسيم إداري البلد  اليمن المحافظة محافظة إب المديرية مديرية السياني العزلة عزلة النقيلين القرية قرية ذي المحاسن السكان التعداد السكاني 2004 السكان 555   • الذكور 258   • الإناث 297   • عدد الأسر 68   • عدد المساكن 61 معلومات أخرى التوقيت توقيت اليمن (+3 غريني...

Danubian Plain (Bulgaria)

Geographic region in northern Bulgaria This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Danubian Plain Bulgaria – news · newspapers · books · scholar · JSTOR (August 2015) (Learn how and when to remove this template message) View across the Danubian Plain towards the central Balkan Mountains 90 km away T...

 

Northwest Science Museum

Creationist museum in Idaho, USNorthwest Science MuseumEstablishedJune 14, 2014 (2014-06-14)Location1835 Wildwood St., Boise, Idaho, USCoordinates43°37′20″N 116°18′57″W / 43.622286°N 116.315965°W / 43.622286; -116.315965TypeCreationist museumFounderDouglas J. Bennett, Brent Carter, Rick Deighton, Stan G. Lutz[1]DirectorDouglas J. BennettWebsitenorthwestsciencemuseum.com Northwest Science Museum is a creationist museum in Idaho. It ope...

 

University of Warwick

Public university in Coventry, England University of WarwickCoat of armsMottoLatin: Mens agitat molemMotto in EnglishMind moves matterTypePublic research universityEstablished1965; 58 years ago (1965)Academic affiliations AACSB ACU AMBA EQUIS European University Association Guild of European Research-Intensive Universities Midlands Innovation Russell Group Sutton 13 Universities UK Endowment£6.9 million (2022)[1]Budget£770.6 million (2021–22)[1...

Warhammer Online: Age of Reckoning

This article relies excessively on references to primary sources. Please improve this article by adding secondary or tertiary sources. Find sources: Warhammer Online: Age of Reckoning – news · newspapers · books · scholar · JSTOR (November 2016) (Learn how and when to remove this template message) 2008 video gameWarhammer Online:Age of ReckoningDeveloper(s)Mythic EntertainmentPublisher(s)Electronic ArtsDesigner(s)Mark Jacobs Paul Barnett Jeff HickmanSe...

 

Claybury Hospital

Hospital in EnglandClaybury HospitalForest Healthcare (NHS) TrustClaybury HospitalLocation within RedbridgeGeographyLocationWoodford Bridge, Redbridge, England, United KingdomCoordinates51°36′11″N 0°04′07″E / 51.6031°N 0.0687°E / 51.6031; 0.0687OrganisationCare systemNHS EnglandTypePsychiatric hospitalServicesBeds2,500HistoryOpened1893 (1893)Closed1997LinksListsHospitals in England Claybury Hospital was a psychiatric hospital in Woodford Bridge, London...

 

Gezer

Platform di Gezer Gezer (Ibrani: גֶּזֶר) adalah nama sebuah kota Kanaan kuno, yang dulu juga merupakan sebuah kerajaan, yang disebut dalam Alkitab Ibrani dan Perjanjian Lama di Alkitab Kristen. Tel Gezer (juga disebut Abu Shusha atau Tell el-Jezer), sekarang merupakan tempat arkeologi penting yang terletak di tengah-tengah antara kota Yerusalem dan Tel Aviv dan menjadi salah satu taman budaya nasional di Israel. Dalam Alkitab, kota Gezer terutama berkaitan dengan Yosua bin Nun dan raja ...

7-Chlorokynurenic acid

7-Chlorokynurenic acid Names Preferred IUPAC name 7-Chloro-4-oxo-1,4-dihydroquinoline-2-carboxylic acid Other names 7-chlorokynurenate; 7-CTKA Identifiers CAS Number 18000-24-3 Y 3D model (JSmol) Interactive image ChemSpider 1813 ECHA InfoCard 100.038.088 PubChem CID 1884 UNII S7936QON2K Y CompTox Dashboard (EPA) DTXSID7042568 SMILES C1=CC2=C(C=C1Cl)NC(=CC2=O)C(=O)O Properties Chemical formula C10H6Cl1N1O3 Molar mass 223.61254 g/mol Except where otherwise noted, d...

 

John W. Jones (ex-slave)

John W. JonesBorn(1817-06-21)June 21, 1817Leesburg, VirginiaDiedDecember 26, 1900(1900-12-26) (aged 83)Elmira, New YorkResting placeWoodlawn CemeteryKnown forConductor on the Underground RailroadSpouseRachel Jones (née Swails) John W. Jones (June 21, 1817 – December 26, 1900), was born on a plantation in Leesburg, Virginia, he was enslaved by the Ellzey family.[1] Jones is buried in Woodlawn National Cemetery, not far from Mark Twain.[2] He was married to Rachel J...

 

Mayor of Dipolog

Local chief executive of the city of Dipolog, Philippines This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Mayor of Dipolog – news · newspapers · books · scholar · JSTOR (September 2020) (Learn how and when to remove this template message) Mayor of Dipolog Mayor sa Dakbayan sa DipologIncumbentDarel Dexter T. ...

Wondrous Strange

2009 fantasy novel by Lesley Livingston The topic of this article may not meet Wikipedia's notability guideline for books. Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be merged, redirected, or deleted.Find sources: Wondrous Strange – news · newspapers · books&...

 

אנך אמצעי

בניית אנך אמצעי לקטע באמצעות סרגל ומחוגה בגאומטריה, אנך אמצעי הוא ישר המאונך לקטע נתון וחוצה אותו (כלומר עובר בנקודת האמצע שלו). האנך האמצעי הוא גם המקום הגאומטרי של כל הנקודות שמרחקן מקצה קטע נתון שווה למרחקן מקציהו האחר של קטע זה. במשולש, שלושת האנכים האמצעים נפגשים בנקודה...

 

Elecciones generales de India de 1989

← 1984 •  • 1991 → Elecciones generales de 1989545 escaños del Lok Sabha273 para obtener la mayoría Fecha 22-26 de noviembre de 1989 Tipo Parlamentaria Resultados Congreso Nacional Indio – Rajiv Gandhi Escaños obtenidos 197  217    39.53 % Janata Dal – Vishwanath Pratap Singh Escaños obtenidos 143      17.78 % Partido Popular Indio – Lal Krishna Advani Escaños obtenidos 85 ...

Saludecio, Rimini

Saludecio Osnovni podaci Država  Italija Regija Emilia-Romagna Provincija Rimini Stanovništvo Stanovništvo (2011) 611 Geografija Koordinate 43°52′31″N 12°39′40″E / 43.8754°N 12.66118°E / 43.8754; 12.66118 Nadmorska visina 308 m SaludecioSaludecio (Italije) Saludecio je naselje u Italiji u provinciji Rimini, u regiji Emilia-Romagna. Prema proceni iz 2011. u naselju je živelo 611 stanovnika.[1][2] Naselje se nalazi na nadmorskoj visi...

 

Canterbury (Victoria)

Kildeløs: Denne artikkelen mangler kildehenvisninger, og opplysningene i den kan dermed være vanskelige å verifisere. Kildeløst materiale kan bli fjernet. Helt uten kilder. (10. okt. 2015) «Canterbury» har flere betydninger. Canterbury Land AustraliaDelstat VictoriaStorbyområdeMelbourneLokalstyreCity of BoroondaraOppkalt etterJohn Manners-Sutton Postnummer3126Areal3 km²Befolkning7 660 (2006)Bef.tetthet2 553,33 innb./km²Høyde o.h.83 meter Canterbury37°49′3...

 

Strategi Solo vs Squad di Free Fire: Cara Menang Mudah!