RE: What does it all mean?

Is there any filter enabled in the SB on the tables tab?   If so, that might be the reason why your NBRCLSH table doesn't show up.


From: [email protected] [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '[email protected]'
Subject: [toad] RE: What does it all mean?


So far as I can tell, both are tables and both have public synonyms. When I look at an F4 DESCribe of them, except for the names I cannot tell them apart. In each case the script begins like this:

ALTER TABLE POSNCTL.NTRPCLS*
DROP PRIMARY KEY CASCADE;

DROP TABLE POSNCTL.NTRPCLS* CASCADE CONSTRAINTS;

CREATE TABLE POSNCTL.NTRPCLS*

*Or NBRCLSH (in black)

When I do an object search on either, I find both the table and the synonym.

To add to my confusion, even though I'm connected as the schema owner, POSNCTL, NBRCLSH is not to be found in the list of Tables. ??? The View and Synonym lists are empty - not a concern.

Dan

P.S. If I'm not using the latest version of Toad, I'm at least close with 11.6.1.6
dbm

From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] RE: What does it all mean?


Hi Daniel,
By chance, is 'nbrclsh' a synonym or view?  To verify, when you do a describe on it, the describe window displays, and on the left hand side, it'll show you the name, owner, and type.

Thanks,
Dennis


From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '[email protected]'
Subject: [toad] What does it all mean?


In my "FROM" clause the first table is you might say, "Grayed out", but not in the usual sense of, "You can't do anything with this." It seems to be somewhat the opposite. In particular, when I use the nt alias for the table followed by a period, the query assist comes to my aid. But when I try the same with the nb alias, no such help. I can DESCribe the black table and query from it just fine. What's going on here?

FROM
     ntrpcls nt,
     nbrclsh nb

TGIF!!

Dan
Daniel B Madvig
Campus Technologies

[cid:[email protected]]<http://nwc.edu/>

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>
651.631.5323

If life gives you melons, you may be lysdexic.