CREATE TABLE Colleges (
college_id INT,
college_code VARCHAR(20),
college_name VARCHAR(50),
CONSTRAINT CollegePK PRIMARY KEY (college_id, college_code)
);
ALTER TABLE Student
ADD CONSTRAINT PK_Student PRIMARY KEY (Rollno,LastName);
ALTER TABLE Colleges
ADD CONSTRAINT CollegePK PRIMARY KEY (college_id, college_code);
Code Example |
---|
Sql :: sql limit order by |
Sql :: create postgres table |
Sql :: creating sql table |
Sql :: min mysql |
Sql :: primary key sql |
Sql :: sql describe |
Sql :: oracle job class |
Sql :: coalesce function in sql server |
Sql :: having clause |
Sql :: sql change column name based on value |
Sql :: not keyword in sql |
Sql :: demmarrer un service mysql teminal cmd |
Sql :: mysqldump devilbox |
Sql :: oracle compile trigger |
Sql :: postgresql find missing id |
Sql :: how to delete python anywhere mysql database |
Sql :: oracle sql all days except weekends |
Sql :: collation in sql |
Sql :: sqlalchemy query sql compiled |
Sql :: cql insert |
Sql :: mysql row generator |
Sql :: sql max value in column |
Sql :: oracle logfile switch |
Sql :: db count rows |
Sql :: postgresql select top 1 from each group |
Sql :: find in set in postgresql |
Sql :: oracle drop program |
Sql :: select query in sql |
Sql :: disable database droping sql |
Sql :: sql date before |