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

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

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)


  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    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,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.