Bug - No suggestion for data types in table create statement anymore

torsten.strauss

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)

Alex B

Hi @torsten.strauss,

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