--The sql is:
SELECT c.TABLE_NAME tableName,
c.COLUMN_NAME fieldName
FROM INFORMATION_SCHEMA.COLUMNS c WITH (NOLOCK)
WHERE c.TABLE_NAME IN ("Table1", "Table2",.....)
AND columnproperty(object_id(c.TABLE_SCHEMA + '.' + c.TABLE_NAME),c.COLUMN_NAME, 'IsIdentity') <> 1
本站僅提供存儲服務，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請
點擊舉報。
