EnVisageOnline/Main/Database/Scripts/20160421/01_Rename_NPT_Allocation_ta...

7 lines
382 B
Transact-SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

Use [EnVisage]
IF (EXISTS (SELECT * FROM sys.tables where name='NonProjectTimeAllocation'))
begin
exec sp_rename 'NonProjectTimeAllocation', 'NonProjectTimeResourceAllocation'
end
GO