Hi,

We have an old VFP application which allowed users to design their own tables (worked fine but a bit clunky under the hood).
Now, moving to SQLServer I'm thinking of simulating multiple tables using a structure like this:

ProductFiles Table
Id

ProductFileColumns
Id
ProductFileId --> ProductFiles.Id

ProductFileRows
Id
ProductFileId --> ProductFiles.Id

ProductFileData
Id
ProductFileColumnId -->ProductFileColumns.Id
ProductFileRowId -->ProductFileRows.Id
Data......

This works fine using triggers to add the neccessary records to ProductFileData whenever a row or column is added to a specific ProductFile. However I think I can do this without a ProductFileRows table.
Adding a row using a SPROC with the ProductFile.Id as a parameter is simple.
However I'm not sure of the best way to code a trigger for when a column is added to ProductFileColumns.
Any help?,
TIA
Viv