clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36289 in the last week).

CREATE TABLE dbo.Something ( Id bigint, OtherId bigint, CONSTRAINT PK_Something PRIMARY KEY (Id) );
 hidden batch(es)


SELECT [name], is_nullable FROM sys.columns c WHERE c.[object_id] = OBJECT_ID('dbo.Something');
name is_nullable
Id False
OtherId True
 hidden batch(es)


ALTER TABLE dbo.Something DROP CONSTRAINT PK_Something;
 hidden batch(es)


SELECT [name], is_nullable FROM sys.columns c WHERE c.[object_id] = OBJECT_ID('dbo.Something');
name is_nullable
Id False
OtherId True
 hidden batch(es)