Do you want to have a trigger firing when a new column is added? In SQL Server 2005 you need to look at DDL triggers.
>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
If it's not broken, fix it until it is.
My Blog