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...