SELECT COLUMN_NAME,'' as ValidateMsg FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ICCS_REP_ICCSC01' AND TABLE_SCHEMA='dbo'
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableName' AND TABLE_SCHEMA='dbo' except SELECT column_name FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS KU ON TC.CONSTRAINT_TYPE = 'PRIMARY KEY' AND TC.CONSTRAINT_NAME = KU.CONSTRAINT_NAME AND KU.table_name='TableName'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)