Start Updating tables in sql server

Updating tables in sql server

Applies to: SQL Server 2016 through SQL Server 2017 and Azure SQL Database.

SCHEMA_AND_DATA is the default value for memory optimized tables.

The value of SCHEMA_ONLY indicates that the table data will not be persisted upon restart of the database with memory optimized objects. The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission.

The other indexed column also had a data type of INT.