SELECT sch.[name] SchemaName, t.name TableName, OBJECTPROPERTY(t.[object_id], 'TableHasIdentity') TableHasIdentity FROM sys.[tables] t INNER JOIN [sys].[schemas] sch ON [sch].[schema_id] = [t].[schema_id] ORDER BY sch.name, t.name
SELECT sch.[name] SchemaName, t.name TableName, OBJECTPROPERTY(t.[object_id], 'TableHasIdentity') TableHasIdentity FROM sys.[tables] t INNER JOIN [sys].[schemas] sch ON [sch].[schema_id] = [t].[schema_id] ORDER BY sch.name, t.name