View:

Well,

a view simply isn't identical to a table, client or not,

and if you try to insert something into a view the error that will pop up will clearly

explain the difference.

so better mark them with a prefix so you can't mix it up ;o)

Reference Table:

I would call a table a reference table if it is i.e. a table which contains a n-m relation.

it just consists of foreign key references and maybe also some content fields,

but the main content is the n to m relation.

In my opinion the number of columns is irrelevant, but the relation by which the data

contained in the table is linked gives the context...

___

Markus Engelhardt

Web and Database Development

MCP