By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 648513 fiddles created (15237 in the last week).
CREATE TABLE dbo.test (PK int IDENTITY, Value int);
✓
hidden batch(es)
SELECT * INTO dbo.test2 FROM dbo.test AS t CROSS JOIN (SELECT 1) AS x (X);
SELECT name, is_identity FROM sys.columns WHERE object_id = OBJECT_ID('dbo.test2') AND name = 'PK';
