stored procedure to change table structure

[faccorp]

Is there a system sp or can I write a sp that can change the structure of a table.

Specifically, i need to be able to remove the 'primary key' attribute and the 'is identity' attribute, manually write some data, then put identity back in.

Thanks,

 

[SQLDenis]

>> 'is identity' attribute, manually write some data, then put identity back in.


use SET IDENTITY INSERT ON
write data and then
SET IDENTITY INSERT OFF
after that you can run DBCC CHECKIDENT to reseed the value

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/