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 vote71 views0 answer
SQL
0 vote145 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote114 views2 answers
Default constraint in ms sql
SQL
16 votes128 views1 answer
Mysql smallint range
SQL
23 votes74 views3 answers
Mysqldump
SQL
1 vote106 views1 answer
Import local sql into remote mysql
SQL
0 vote122 views1 answer
Sql server beginning of month
SQL
0 vote121 views1 answer
Sql beginning of previous month
SQL
4 votes121 views4 answers
Oracle tablespace tables list
SQL
0 vote120 views2 answers
Get all index postgres
SQL