Archives of the TeradataForum
Message Posted: Wed, 20 Oct 2004 @ 14:14:46 GMT
| Subj: || || Accessing DBC.IdCol table for Identity Parameters |
| From: || || Jamsandekar, Smitesh |
I need to access the contents of DBC.IdCol to get the values of StartValue, MinValue, MaxValue, Increment. However this seems to be FALLBACK
protected table(not sure what this means) and when I try to do a Select * on this I get "3523: The user does not have SELECT access to
Any Idea how do I go about getting these values. Is there any view or Stored Procedure associated to retrieve these values.