I was wondering what the SQL command is to find the filed names of a
database once it has been created.
I'm trrying to write a script that will allow 'options' table to be created
where there is an ID fiield for the product then fields representing each of
the avalible options eg red blue green which are going to be a boolean
variable. I'm hopeing that this is the best way tyo do this as each product
can have multiple options and there may even be more option fields added at
a later date (which is why I need to be able to find them)
My table design:
___________________________________________
| Product_ID | Red | Blue | Green | Yellow | A4 | A5 |
|------------------|--------|---------|----------|-----------|------|------|
|_12345678_|__+__|_____|__+__|__+___|____|____|
|_75487345_|_____|__+__|___+_|______|_+__|__+_|
|_43657322_|_____|_____|_____|______|____|____|
|_12355578_|__+__|_____|__+__|__+___|____|____|
|_66635678_|_____|__+__|__+__|__+___|_+__|____|
