1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| CREATE TABLE TEST
(
C INT NOT NULL CONSTRAINT PK_TEST PRIMARY KEY,
D CHAR(1) NOT NULL
)
GO
SET NOCOUNT ON
GO
INSERT INTO dbo.TEST VALUES (1, 'Z')
INSERT INTO dbo.TEST VALUES (2, 'Y')
INSERT INTO dbo.TEST VALUES (3, 'X')
INSERT INTO dbo.TEST VALUES (4, 'W')
INSERT INTO dbo.TEST VALUES (5, 'V')
GO
DELETE FROM dbo.TEST
WHERE C = 3
GO
INSERT INTO dbo.TEST VALUES (6, 'A')
GO
SELECT *
FROM dbo.TEST
-----------------------------------------
TRUNCATE TABLE dbo.TEST
GO
ALTER TABLE dbo.TEST
DROP CONSTRAINT PK_TEST
GO
INSERT INTO dbo.TEST VALUES (1, 'Z')
INSERT INTO dbo.TEST VALUES (2, 'Y')
INSERT INTO dbo.TEST VALUES (3, 'X')
INSERT INTO dbo.TEST VALUES (4, 'W')
INSERT INTO dbo.TEST VALUES (5, 'V')
GO
DELETE FROM dbo.TEST
WHERE C = 3
GO
INSERT INTO dbo.TEST VALUES (6, 'A')
GO
SELECT *
FROM dbo.TEST |
Partager