What are the challenges you face when working across database platforms? Take the survey
Options

BUG: INSERT auto-fill doesn't find all columns

zeffizeffi Posts: 3
edited January 11, 2016 9:36AM in SQL Prompt
If the userdefined datatype of a column has the same name as a table in the database, the autofill of INSERT columns doesn't find these columns:

CREATE TYPE [dbo].[Anvandare] FROM [VARCHAR](16) NOT NULL;

CREATE TABLE Anvandare ( ID INT );

CREATE TABLE [dbo].[Test]
(
ID INT
,Name [dbo].[Anvandare] NOT NULL
);
/*
here I "refresh suggestions"
after that the autofill of the INSERT-statement
will not include the Name-column because the name
of the type is the same as the name of the table Anvandare
*/
INSERT INTO dbo.Test
( ID )
VALUES
( 0 -- ID - int
)

Comments

Sign In or Register to comment.