[sqlite] Bug getting ROWID datatype?

[Tito Ciuro]

Hello,
When I retrieve ROWID's datatype, I get INTEGER. Shouldn't it be 
INTEGER PRIMARY KEY, the way I created it? The questions arises when 
performing  the ALTER-like operation as shown here:

http://www.sqlite.org/faq.html#q13
If I trust SQLite, then I'll add ROWID with an INTEGER datatype. Will 
this affect the way SQLite treats ROWID? Or is SQLite smart enough to 
know that ROWID is a special type of column, therefore treating it as 
INTEGER PRIMARY KEY?

Thanks,
-- Tito
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]