Hi everybody,

I'm trying to make a right choice for the new table design. It is going to have only few columns one being its primary key and it's a 10 digit number. I'm thinking that BIGINT is a good choice for this column, but my colleagues are arguing that most of other tables that have the same column use either char(10) or varchar column. I found that we're very inconsistent in the length of that column and we even have a few tables using INT for this column (or nchar/nvarchar).

Anyway, what do you think the correct decision should be - the table is new and it is supposed to be relatively small (perhaps ~1K rows in total at most). I already designed it using BIGINT for the PK, but given the fact that many of the tables already use char for the same purpose, should I probably switch to char(10) instead?

Thanks in advance.

----------------------------
BTW, we may want to add SQL Server 2019 and SQL Server 2017 as other versions available.