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 vote265 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote318 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote272 views1 answer
Str_to_date sql server
SQL
0 vote273 views1 answer
Mysql c commands
SQL
0 vote276 views1 answer
Hoq to import database source
SQL
0 vote259 views1 answer
Drop a field in psql django
SQL
9 votes268 views2 answers
Sql server check table exists
SQL
0 vote254 views1 answer
View acl table oracle
SQL
1 vote276 views1 answer
Too many connections mysql
SQL
1 vote263 views1 answer
Moodle query first user access
SQL