Search
 
SCRIPT & CODE EXAMPLE
 

SQL

SQL Primary Key With Multiple Columns

CREATE TABLE Colleges (
  college_id INT,
  college_code VARCHAR(20),
  college_name VARCHAR(50),
  CONSTRAINT CollegePK PRIMARY KEY (college_id, college_code)
);
Comment

primary key multiple colums

ALTER TABLE Student
ADD CONSTRAINT PK_Student PRIMARY KEY (Rollno,LastName);
Comment

SQL Primary Key multiple column

ALTER TABLE Colleges
ADD CONSTRAINT CollegePK PRIMARY KEY (college_id, college_code);
Comment

PREVIOUS NEXT
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 
ADD CONTENT
Topic
Content
Source link
Name
5+8 =