http://dbis-vl2.wikidata.dbis.rwth-aachen.de/index.php?action=history&feed=atom&title=Slide%2FSQL_PRIMARY_KEY 2026-07-22T15:48:58Z Revision history for this page on the wiki MediaWiki 1.39.1 http://dbis-vl2.wikidata.dbis.rwth-aachen.de/index.php?title=Slide/SQL_PRIMARY_KEY&diff=625&oldid=prev 2023-04-05T07:12:56Z

<p>modified through wikirestore by Sysop</p> <p><b>New page</b></p><div>== Links ==<br /> <br /> * {{Link|target=lg/SQL-DDL-PrimaryKey|title=SQL-DDL-PrimaryKey}}<br /> <br /> * {{Link|target=keyword/SQL|title=SQL}}<br /> * {{Link|target=keyword/SQL Syntax|title=SQL Syntax}}<br /> * {{Link|target=keyword/PRIMARY KEY|title=PRIMARY KEY}}<br /> <br /> <br /> <br /> == Links hierher ==<br /> {{WhatLinksHere}}<br /> &lt;pdf page=&#039;24&#039;&gt;4-RelationaleDatenbankspracheSQL.pdf&lt;/pdf&gt;<br /> = Meta =<br /> {{Slide<br /> |qkey=SQL-24<br /> |pkey=SQL<br /> |basename=4-RelationaleDatenbankspracheSQL.pptx<br /> |page=24<br /> |pdf_page=24<br /> |name=SQL_PRIMARY_KEY<br /> |title=PRIMARY KEY<br /> |keywords=SQL, SQL Syntax, PRIMARY KEY<br /> |links=<br /> |literature=<br /> |learningGoal=lg/SQL-DDL-PrimaryKey<br /> |storemode=property<br /> }}<br /> = Text =<br /> &lt;pre&gt;<br /> PRIMARY KEY<br /> Die •PRIMARY KEY •Einschränkung ist äquivalent zu „•NOT NULL UNIQUE•“•Verschiedene Möglichkeiten zur Festlegung eines Primary Keys• •CREATE TABLE Kunde•( KName CHAR (20) NOT NULL UNIQUE, KAdr VARCHAR (50),• Saldo DECIMAL (7) , • •PRIMARY KEY (KName)• )••oder• CREATE TABLE Kunde•(•KName• CHAR (20) NOT NULL UNIQUE •PRIMARY KEY•, KAdr VARCHAR (50), • Saldo DECIMAL (7) )••oder• CREATE TABLE Kunde•( KName CHAR (20) NOT NULL UNIQUE, KAdr VARCHAR (50), Saldo DECIMAL (7), •CONSTRAINT pk_kunde PRIMARY KEY (KName) •)<br /> <br /> <br /> &lt;/pre&gt;<br /> &lt;headertabs/&gt;</div>

Sysop