tablecolumnused.sql

Java写的ERP系统

--	Table Column Used
SELECT t.AD_Table_ID, t.TableName, c.AD_Column_ID, c.ColumnName, 
	DBA_DisplayType(c.AD_Reference_ID) AS DisplayType, AD_Reference_Value_ID, c.isKey, c.IsParent 
FROM AD_Table t, AD_Column c
WHERE t.AD_Table_ID=c.AD_Table_ID
  AND c.ColumnName='C_Location_ID'
ORDER BY c.IsKey Desc, c.IsParent Desc, t.TableName;
/**
	UPDATE AD_Column c SET AD_Reference_ID=28 -- Button
	WHERE AD_Reference_ID<>28 
	  AND ColumnName='Posted';
  	COMMIT;
/**	**/