Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-12 : 07:47:07
|
| Rajesh writes "Hi,I need to customize fields with respect to an object from an application .For example, "customer" is a logical object and it's database object name is "tblCustomer". End user may like to add new fields in "customer". New field may be in any type. I think to use another table "tblCustomField" which contains "customerId","newfieldtype" (int) and "newfieldvalue" ( varchar(1000) ).Is it the best way to do it ?" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-12 : 08:54:01
|
adding columns from an application is a bad thing.rather then searching the answer to this, normalize your database.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Customize Fields