Tables not listed in intellisense...
I have created a basic schema structure with 10 tables in it. In creating each table, I simply right-clicked on the TABLE and selected "New Table..." and tapped in the details, setting the primary keys. When completed, I created the database diagram and used that to create the foreign keys.
Next step, creating first stored procedure, in which the procedure takes in two sets of data ... let's say DRIVER and VEHICLE with the idea that some data is checked for presence in a table, added if needed and then a second insert complete.
So, if the car exists in the VEHICLE table, there's no need to add it - just pull the ROWID which is added as a value to the DRIVER table. If the car isn't there, add it ... then pull the ROWID.
When I added the code for INSERT INTO VEHICLE... it was fine
When I added the code for SELECT @CAR_ID = ID FROM VEHICLE... that was fine, too
Problem...
INSERT INTO ... intellisense pops up at this point, but only the VEHICLE table is listed (other than the system tables) and I can't navigate to my table, whether direct by name, through dbo.<name> or by <schema>.dbo.<name>
Apologies for all the "bumpf" in this, but thought I would offer as much information as I could provide ... and/all help appreciated.
Sean
__________________
Regards,
Sean
|
