Can a primary key contain a column that is defined as a date column?
Hi Greg Hackett Yes, a DATE or a DATETIME type column can be a part of the Primary Key. Is there any particular case that you have in mind?
Yes, a Developer wants an AR_AGING_HISTORY table created with primary key being AS_ID & AS_OF_DATE columns. I do not know any details. The table will be a ThoughtSpot table.
I see, it should work just fine in this case.
That's exactly what I needed to know. Thanks very much!
MEET A PRO (OFFICE HOURS)
THOUGHTSPOT U (TRAINING & CERTIFICATION)
GITHUB COMMUNITY TOOLS