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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to add a new table to an exist database

Author  Topic 

accesser2003
Starting Member

14 Posts

Posted - 2007-08-11 : 01:12:08
Is is possible to add new table to an exist database using the osql utility and without affecting the data in this database.
The database I have is as follow:

- Database name: AMDB
- Server Name: BNC
- Instance Name: AMDESKINSTANCE


The new table I want to add is called: UserInSystem

So What is the sql statement to acgieve this by using osql utility from the command propmt?

Appreciaitive,

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-11 : 10:14:52
duplicate. locked.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page
   

- Advertisement -