Primary key multiple

CREATE TABLE Persons (
    Rollno int NOT NULL,
    FirstName varchar(30),
    LastName varchar(30) NOT NULL,
    class varhcar(20),
    Age int,
    CONSTRAINT PK_Student PRIMARY KEY (Rollno,LastName)
);

Source: computerscienceai.com

Similar codes

0 vote354 views1 answer
Oracle exchange partition
SQL
3 votes367 views1 answer
Postgresql db owner change
SQL
9 votes397 views4 answers
Mysql set id auto increment
SQL
0 vote362 views1 answer
Sql dmv to capture updates
SQL
5 votes409 views1 answer
Oracle ora-00054 find
SQL
0 vote361 views1 answer
What is default mysql database password in linux
SQL
8 votes381 views1 answer
Sql remove leading spaces
SQL
0 vote378 views1 answer
Sql today at midnight
SQL
3 votes353 views4 answers
Mysql delete duplicate rows
SQL
0 vote342 views1 answer
Mysql_error replacement
SQL