|
|
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
DBC.IdCol".
Any Idea how do I go about getting these values. Is there any view or Stored Procedure associated to retrieve these values.
Thanks
| |