Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XML as a field
Message
From
11/07/2002 13:56:32
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Miscellaneous
Thread ID:
00677659
Message ID:
00677661
Views:
22
>I was just in a meeting where the database designers are adding flexibility by doing the following:
>Any new fields that is added to a column, will go into the last field of a table that is an XML string. This String will allow for multiple fields to be added dynamically.
>Do you think this is a good idea?
>What are the drawbacks?? Can you search on this field in the string?

By column, do you mean table?

If this regards to gathering data from various sources/types into one single field, than you will end up with less flexibility for your tags, manipulations, etc. But, again, maybe you have some good advantages for your requirements to do it like that.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform