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 vote186 views1 answer
Get a list of tables and the primary key
SQL
0 vote187 views1 answer
Sql server list user permissions
SQL
0 vote176 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote182 views1 answer
Copy value from one column to another postgres
SQL
1 vote166 views1 answer
Mysqli connect
SQL
4 votes134 views1 answer
Oracle sleep
SQL
7 votes207 views1 answer
Sql pagination oracle
SQL
25 votes170 views4 answers
Metadata
SQL
0 vote175 views2 answers
Mysql get routine parameter list
SQL
1 vote191 views1 answer
Postgresql create table with timestamp
SQL