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 |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2006-11-28 : 21:44:22
|
| Hi,I have about 20 mobile users that running the SQL database on their laptop, now I want to add a new table in the database, what is the best way to do it without interface the existing data? The application is written in VB6, how can I add the new table to the their existing database?Thanks! |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-28 : 23:06:53
|
| Just create and execute a command like you would for any SELECT, INSERT, UPDATE or DELETE, but make it a CREATE TABLE statement instead. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-29 : 02:07:26
|
| >>I want to add a new table in the database, what is the best way to do it without interface the existing data? Adding new table wont affect existing data of any tableMadhivananFailing to plan is Planning to fail |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-29 : 03:22:30
|
quote:
Adding new table wont affect existing data of any table
Yes, but you would have to make necessary changes in the application to refer to this table...otherwise, what good this table will be?Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
|
|
|
Add a new table?