26 lines
366 B
Transact-SQL
26 lines
366 B
Transact-SQL
USE EnVisage
|
|
GO
|
|
|
|
IF EXISTS
|
|
(
|
|
SELECT 1
|
|
FROM sys.columns
|
|
WHERE object_id = OBJECT_ID('Skill')
|
|
AND name = 'OrderNumber'
|
|
)
|
|
BEGIN
|
|
ALTER TABLE dbo.Skill DROP COLUMN OrderNUmber
|
|
END
|
|
|
|
IF EXISTS
|
|
(
|
|
SELECT 1
|
|
FROM sys.columns
|
|
WHERE object_id = OBJECT_ID('Skill')
|
|
AND name = 'DateEdited'
|
|
)
|
|
BEGIN
|
|
EXEC sp_RENAME 'Skill.DateEdited' , 'EditTimestamp', 'COLUMN'
|
|
END
|
|
|