Back to list
Views:   3.5K
Replies:  0

Custom Column Pattern - SQL Design Patterns


I am not sure if this works or i misunderstood.

For Custom Column Pattern In Meta Model,  following SQLs have been mentioned to retrieve and display s student record.

1) SELECT Id, FirstName, LastName, Email FROM Student WHERE Id = 29

2) SELECT C.Name, V.Value FROM [Column] C JOIN [Value] V ON C.Id = V.ColumnId WHERE C.WhatId = 29

WhatId is a foreign key that points to a record in Student table which is identity column.

If we added custom columns for Course table, Id column in Course table will have value 29 and second query will get result for both tables (Student and Course).

Please advise.

Manohar Shaghanti, Nov 05, 2016
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.