posted 10 years ago
If a table should always keep identical data in column B, why to keep that column in the table at all? It is a strange requirement which probably indicates a less than optimal design somewhere. But if you really need such a setup - two identical columns A and B - you can easily achieve that by only having the column A in the table and creating a view containing all the table's columns plus another instance of column A aliased to "B".