Options
Bug - No suggestion for data types in table create statement anymore
torsten.strauss
Friend of Redgate › Posts: 266 Silver 3
in SQL Prompt
Hi Redgate Team,
Since the last update SQL Prompt will not suggest any data types when writing a table create statement.
Start typing the following statement will miss any data type suggestion
CREATE TABLE test (col1
Is this a know issue ?
Thanks for support!
Torsten (MVP)
Since the last update SQL Prompt will not suggest any data types when writing a table create statement.
Start typing the following statement will miss any data type suggestion
CREATE TABLE test (col1
Is this a know issue ?
Thanks for support!
Torsten (MVP)
Tagged:
Answers
The only way I can get it to not suggest a data type is if the table of the same name already exists. This is in SQL Prompt 10.1.0 on SSMS 18.4.
In my example here you can see it suggests for table testunique, but it doesn't for table test and we can see the red squiggle indicating the object already exists.
Is this what is occurring for you? If not, what version of SQL Prompt and what version of SSMS and SQL Server are you connecting to? Are you able to share a screenshot or image?
Kind regards,
Alex
Have you visited our Help Center?