General information
Forum:
Microsoft SQL Server
Title:
Simulating multiple tables
Environment versions
SQL Server:
SQL Server 2005
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only