ALTER TABLE t ADD my_new_col VARCHAR PRIMARY KEY The new column must be nullable and the last existing PK column cannot be nullable and fixed width (or varbinary or array).
On Tue, Jul 14, 2015 at 10:01 AM, Riesland, Zack <[email protected]> wrote: > This is probably a lame question, but can anyone point me in the right > direction for CHANGING and EXISTING primary key on a table? > > > > I want to add a column. > > > > Is it possible to do that without dropping the table? > > > > Thanks! > > > > >
