SQL DROP

Tablo silme: DROP TABLE IF EXISTS MY_TABLE; DROP TABLE MY_TABLE; Kolon silme: ALTER TABLE BK_ROM_WOR.dbo.NAV_DAT DROP COLUMN IF EXISTS my_column; ALTER TABLE BK_ROM_WOR.dbo.NAV_DAT DROP COLUMN my_column; INDEX silme: IF EXISTS (SELECT * FROM sys.indexes WHERE name=’UQ_DCU’) DROP INDEX UQ_DCU ON BK_ROMS_WORK.dbo.DP_C_USER; CREATE UNIQUE INDEX UQ_DCU ON DP_C_USER (EMPLID); DROP INDEX UQ_CU ON BK_RO_WO.dbo.DP_C_US Stored Procedure silme: IF EXISTS (SELECT name FROM sys.objects WHERE name = ‘sp_SEN_DAT_NAV’) DROP PROCEDURE dbo.[dbo.sp_SEN_DAT_NAV] ]]>

Leave a Reply

Your email address will not be published. Required fields are marked *