SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE T (ID int);
INSERT INTO T(ID)
VALUES (1),(2),(3),(4),(5),(6),(7),(9);
8 rows affected

SELECT *
FROM T;


ID


1

2

3

4

5

6

7

9


ALTER TABLE T ADD timestamp;
SELECT *
FROM T;


ID
timestamp


1
0x00000000000007D1

2
0x00000000000007D2

3
0x00000000000007D3

4
0x00000000000007D4

5
0x00000000000007D5

6
0x00000000000007D6

7
0x00000000000007D7

9
0x00000000000007D8

ID	timestamp
1	0x00000000000007D1
2	0x00000000000007D2
3	0x00000000000007D3
4	0x00000000000007D4
5	0x00000000000007D5
6	0x00000000000007D6
7	0x00000000000007D7
9	0x00000000000007D8