Id Auto Increase (edit)
https://stackoverflow.com/questions/13772019/sql-check-if-a-column-auto-increments
ALTER TABLE YourTable DROP COLUMN IDCol
ALTER TABLE YourTable ADD IDCol INT IDENTITY(1,1)
SELECT
'Diary' as Table_Name
, 'Id' as Column_Name,
case is_identity
when 1 then 'True'
when 0 then 'False'
end as Is_Identity
FROM sys.columns
WHERE
object_id = object_id('Diary')
AND name = 'Id'
