Columns name to SeqName

[c***@hotmail.com]

How to get the sequence name from the table.column name?
Assume Column name is primary name.

Thanks.

[Knut Stolze]

Post by c***@hotmail.com
How to get the sequence name from the table.column name?
Assume Column name is primary name.

A sequence is not tied to a column. So could you describe what exactly you
mean?

[c***@hotmail.com]

Yes!
I just confirm this...

So sequence number is act more like a GLOBAL variable.
It can use by any table any time they want....

B4 that I thought it is tied with column and table.
BUT I am wrong...:<

Thanks.

[Knut Stolze]

Post by c***@hotmail.com
Yes!
I just confirm this...
So sequence number is act more like a GLOBAL variable.
It can use by any table any time they want....
B4 that I thought it is tied with column and table.
BUT I am wrong...:<

IDENTITY columns are tied to a table.