advice Question

Creating (applications user defined) dynamic table inside SQL Server

Avatar of Freenzy Freenzy
Freenzy FreenzyFlag for Slovenia asked on
Microsoft SQL ServerSQL
2 Comments1 Solution22 ViewsLast Modified:

In my application i'm creating (applications user defined) dynamical tables inside SQL Server. Here is the E-R diagram for creating dynamical tables.

After dynamical table is created, and data is loaded, application converts dynamical table to static table witch is just ordinary table in SQL Server for easy querying, indexing, etc

If structure change in dynamical Table, application automatically recerate static table. Structure of dynamical Table changes rarely. This solution works fine in production.

Someone told me, this is anti pattern for creating dynamical tables.  If this is anti-pattern, how do you suppose to create dynamical tables in SQL? What would be better solution for easy querying, indexing,etc, than creating static table?

Senior Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros