Table Variable with constraint bug

GlennGlenn Chattanooga, TNPosts: 2 Bronze 3
Appears that "Global/Lists/Commas/Place Commas before items" and "Statements/Schema (DDL)/Data types and constraints/Place constraints on new lines" is causing weird comma placement and constraint alignment on table variables.

Sample code:
DECLARE @work TABLE( key1 VARCHAR(4)
, key2 VARCHAR(9)
, val1 VARCHAR(50)
, val2 VARCHAR(25),
PRIMARY KEY CLUSTERED( key1, key2 ));

CREATE TABLE #work ( key1 VARCHAR(4)
, key2 VARCHAR(9)
, val1 VARCHAR(50)
, val2 VARCHAR(25)
,
PRIMARY KEY CLUSTERED( key1, key2 ));
dflwj94py3eg.png

Tagged:

Answers

Sign In or Register to comment.