×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: T-SQL
Posted by: user2d6c2
Added: Jun 30, 2017 8:27 PM
Modified: Jun 30, 2017 8:28 PM
Views: 2
Tags: no tags
  1. IF EXISTS ( SELECT 1 FROM sys.columns WHERE name = N'IsDeletedFromSource'  AND object_id = OBJECT_ID(N'dbo.ContractorHistoryDim') )
  2.         ALTER TABLE dbo.ContractorHistoryDim
  3.                 DROP COLUMN IsDeletedFromSource;
  4. GO