• You should not even be considering updating the system tables unless you are willing to deal with a corrupt and unusable database afterwards. Say you did update the xtype, now the system tables shows it's an int (4 bytes), but the data pages themselves still have 8 bytes (bigint) allocated to the columns. That'd cause one hell of a mess and likely some nasty messages.

    If you want to convert the column from bigint to int, you do it the same way as the conversion from int to bigint.

    ALTER TABLE <Table Name>

    ALTER COLUMN <Column Name> <new data type> <nullability>

    As an example

    ALTER TABLE MyTable

    ALTER COLUMN SomeColumn INT NULL

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass