sorry if this has been picked up before...
Is there a reason why SQL Pormpt only fills in the column name and not the view when it offers the prompt? When I enter Select * from and hit the space I am being offered the information_schema views (INFORMATION_SCHEMA.COLUMNS) but when I select one of these and hit enter or tab in Query analyzer it only picks up the column name. This leads of course to an nivalid object name error. Is there an option I missed somewhere?
N
Is there a reason why SQL Pormpt only fills in the column name and not the view when it offers the prompt? When I enter Select * from and hit the space I am being offered the information_schema views (INFORMATION_SCHEMA.COLUMNS) but when I select one of these and hit enter or tab in Query analyzer it only picks up the column name. This leads of course to an nivalid object name error. Is there an option I missed somewhere?
N