Originally posted by vaibhav punekar:
We wish to transfer database from one premises to other as well as admin should be able to add new premise altogether. [...] How can I achieve this?
The syntax is
Oracle: ALTER TABLE table ADD (column datatype)
SQL Server: ALTER TABLE table ADD column datatype
Others: something else again
But having said that...
re-think your database design!!! It is bad practice to design a schema in such a way that you have to modify it on a regular basis. If you have a variable number of premises, model them as such in your schema.
This is actually a general point: if you have multiple copies of something, say a telephone number associated with a customer, do not be tempted to model it like
but always model it like
unless you are very, very sure that there absolutely never will be more than a certain number of copies. But in most cases, when you hold multiple copies of something, someone will ask you for fewer or more copies.
- Peter
[This message has been edited by Peter den Haan (edited June 14, 2001).]