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

ALTER TABLE incorrect tool-tip

MikeyCMikeyC Posts: 249 Bronze 3
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

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.