Thank this author by sharing:
By Patricia Schiefelbein,
I would like to ALTER Primary Column data type to INT from NUMERIC. Foreign key relationships are th...
working with primary key column
Adding Primary key column to existing table
Adding identity property on primary key column
Will list Table Name, Constraint name and Primary Key Column Name.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.