SQL Server Silinmeyen Stunları Silinmeyen Tabloları Silme Kodu Etkilidir.

/* =========================================
   CREATE_NEW_CHAR_SET2369
   xIndex AUTO IDENTITY SYSTEM
   ========================================= */

/* xIndex varsa sil */
IF EXISTS (
    SELECT *
    FROM sys.columns
    WHERE object_id = OBJECT_ID('CREATE_NEW_CHAR_SET2369')
    AND name = 'xIndex'
)
BEGIN
    ALTER TABLE CREATE_NEW_CHAR_SET2369
    DROP COLUMN xIndex;
END
GO

/* xIndex tekrar oluştur */
ALTER TABLE CREATE_NEW_CHAR_SET2369
ADD xIndex INT IDENTITY(1,1) NOT NULL;
GO

INSERT INTO CREATE_NEW_CHAR_SET2369
(CharID, ItemID)
VALUES
(1, 379001000);

1
2
3
4
5

DROP TABLE CREATE_NEW_CHAR_SET2369;

ALTER TABLE CREATE_NEW_CHAR_SET2369
DROP COLUMN xIndex;

DELETE FROM CREATE_NEW_CHAR_SET2369;

DBCC CHECKIDENT ('CREATE_NEW_CHAR_SET2369', RESEED, 0);

DELETE FROM CREATE_NEW_CHAR_SET2369
WHERE xIndex = 5;

SELECT *
FROM CREATE_NEW_CHAR_SET2369;

SELECT TOP 1 *
FROM CREATE_NEW_CHAR_SET2369
ORDER BY xIndex DESC;