How can we help you today? How can we help you today?

Table Variable with constraint bug

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

Glenn
0

Comments

2 comments

Sort by

Add comment

Please sign in to leave a comment.