CoboCards App FAQ & Wishes Feedback
Language: English Language
Sign up for free  Login

Get these flashcards, study & pass exams. For free! Even on iPhone/Android!

Enter your e-mail address and import flashcard set for free.  
Go!
All main topics / Informatik / SQL

SQL (26 Cards)

Say thanks
12
Cardlink
0
Wie sieht die DDL der folgenden Tabelle aus:
Kunde(PK_KundenId, Name, Vorname, Telefonnummer, Adresse, PLZ, Ort)
CREATE TABLE Kunde (
  PK_KundenId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  Name VARCHAR(50),
  Vorname VARCHAR(50),
  Telefonnummer CHAR(15),
  Adresse VARCHAR(75),
  PLZ INT,
  Ort VARCHAR(75)
)
Tags: AUTO_INCREMENT, CREATE, Datenbank, ddl, mysql, PRIMARY KEY, sql, table
Source:
Flashcard set info:
Author: Stejan
Main topic: Informatik
Topic: SQL
School / Univ.: ZbW
City: St. Gallen
Published: 04.03.2011
Tags: sql database datenbank
 
Card tags:
All cards (26)
ALL (1)
AUTO_INCREMENT (1)
bedingung (1)
befehl (1)
case sensitive (1)
CHAR (1)
column (1)
Constraint (1)
constraints (1)
create (3)
CREATE (2)
data dictionary (2)
database (1)
datenbank (2)
Datenbank (24)
datenbasis (2)
datentyp (1)
dbms (1)
dbs (1)
ddl (3)
definition (2)
DELETE (1)
DESC (1)
detail-tabelle (2)
DISTINCT (1)
dml (2)
dql (2)
FOREIGN KEY (1)
FROM (1)
INSERT (2)
join (1)
kartesisches produkt (1)
like (1)
master-tabelle (2)
mysql (1)
NULL (1)
ON DELETE CASCADE (1)
ON DELETE SET NULL (1)
ON UPDATE CASCADE (1)
ON UPDATE SET NULL (1)
ORDER BY (1)
Primärschlüssel (1)
PRIMARY KEY (3)
referenz (1)
relationen algebra (1)
schema (1)
SELECT (3)
selektion (1)
spalte (1)
sql (18)
SQL (3)
statement (1)
tabelle (1)
table (4)
TABLE (1)
union (2)
UNION (1)
UPDATE (1)
VARCHAR (1)
Report abuse

Cancel
Email

Password

Login    

Forgot password?
Deutsch  English