Re: Can a Table be Invalidated?

khatri wrote: 
Well Andreas, i feel there is a possibility that a table can be
invalidated. Just think in reference to the following:
If an object is referenced through a stored procedure then when you
access that procedure all the referenced objects are compiled at run
time. But in a later course, if you alter the procedure, at the time
all the referenced objects are invalidated. Is this justifies that a
table can be invalidated if referenced in a strored procedure? i don't
know. just try.


A (relational) table can not reference procedure. If a table name occurs within a stored procedure it means, stored procedure references this table and not the table references that stored procedure. So if you alter a stored procedure, the table can not be invalidated.

Best regards

Maxim
.

Relevant Pages

  • Re: Stored procedure to check the syntax of stored procs, views, ...
    ... I use a stored procedure called sp_grep. ... syscomments table and look for references to your target string. ... user functions, views, etc. that contain a reference to this object. ... Since you're looping through sysobjects, you can filter out any object ...
    (microsoft.public.sqlserver.programming)
  • Table Locking
    ... I think I need some good references to SQL Server to learn ... some basic functions. ... I have a stored procedure that creates document numbers ...
    (microsoft.public.sqlserver.programming)
  • Re: Table Locking
    ... >John Dickey wrote: ... >> I think I need some good references to SQL Server to ... >> I have a stored procedure that creates document numbers ...
    (microsoft.public.sqlserver.programming)
  • DeleteAllowed stored proc.
    ... I'm thinking of stored procedure, which is called from client application ... and user interface ... allows/dissalows deletion of records loaded onto form if references to the ...
    (microsoft.public.sqlserver.programming)
  • Re: Help with Update Query
    ... May I ask why this is ALTER ... As for the Update statement in the stored procedure, ... load the tables with sample data, in addition to all the Transact-SQL ... DDL, INSERTS, and T-SQL here and I'll take a look at it. ...
    (microsoft.public.access.queries)