Thread: stored procedures

Hi all
i have a table called dbo.priorites which contains 2 columns
_codepriorite varchar (20) primary key
_priorite varchar (50) null

so i was asked to change _codepriorite varchar (20) into _codepriorite int(4)

it worked with this script

alter table dbo.priorites
drop constraint pk_priorites
go

alter table dbo.priorites
drop column _codepriorite
go

alter table dbo.priorites
add _codepriorite int identity
go

alter table dbo.priorites
add primary key (_codepriorite)
go


i wanna use this script from the compiler , like with stored procedures... I wanna call this script from the software im working with... Any ideas on how to do it? ill be thankful for some help...