Competition: What’s your favorite Redgate tool? Enter now.

ALTER TABLE incorrect tool-tip

CodantiMCodantiM Posts: 245
edited April 2, 2010 12:51PM in SQL Prompt Previous Versions
With this code:
ALTER TABLE msdb.dbo.backupfile ALTER COLUMN media_set_id<cursor> VARCHAR(10);

If you hit ctrl-space it shows information about the media_set_id field in the BackupMediaSet table. The field doesn't exist in the BackupFile table so there should be "no suggestions" like there is if you take the d off the end. (It only appears to show incorrect suggestions if the field name is an exact match to a field in a different table.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Michael,

    Thanks for contacting us. This is an odd problem and I don't have an explanation for it at this time. I'll log a bug about it and let you know what happens.
Sign In or Register to comment.