EnVisageOnline/Main/Database/Scripts/20160217/03_add_fields_to_NPTime.sql

7 lines
208 B
Transact-SQL

Use EnVisage
Go
IF not EXISTS(SELECT * FROM sys.columns
WHERE Name = N'Details' AND Object_ID = Object_ID(N'NonProjectTime'))
ALTER TABLE NonProjectTime
ADD Details nvarchar(500), Permanent bit