Find Microsoft SQL Server database tables without an identity column

tables-without-an-identity-column.sql

SELECT 
	S.name AS SchemaName
	,T.name AS TableName

FROM sys.tables AS T
	INNER JOIN sys.schemas AS S ON ( T.schema_id = S.schema_id )

WHERE NOT EXISTS ( 
		SELECT *
		FROM sys.columns AS C
		WHERE C.object_id = T.object_id
			AND C.is_identity = 1
	)
	
ORDER BY S.name, T.name;