Member Avatar for ntk

I have an existing table:

CREAT TABLE Course
(CourseNo       int    NOT NULL    PRIMARY KEY,
CourseName   varchar NOT NULL
StudentNo       int    NOT NULL    REFERENCES Student (StudentNo))

Is it possible to code the following change in T-SQL:
Introduce a new column called CourseID (int NOT NULL) and make it the PK? In other words, remove CourseNo from being the PK and make CourseID the new PK without dropping the column CourseNo?

Let's just put aside the business case for this change and assume it to be a theoretical pursuit.

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by urtrivedi
Member Avatar for urtrivedi

You can do it using alter table table1 add (courseId numeric(10))
then update table1 set courseid=courseno then alter table table1 drop "pkoldname" then alter table table1 add primary key pknewname (courseid) You can also user enterprise manager to do above operation using gui.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.