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:09:33
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,

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-11 : 01:26:47
Yes, use 'create table' statement. Each db can have many tables.
Go to Top of Page

accesser2003
Starting Member

14 Posts

Posted - 2007-08-11 : 02:18:15
But how, would you please give me the full statement.

Thanks,
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-11 : 18:34:42
Can't because don't know what you like to put in the table, check books online for detailed syntax.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-12 : 03:30:08
Let the fun begin!

CREATE TABLE UserInSystem
(
Col1 INT,
Col2 VARCHAR(5000),
Col3 DATETIME
)

And don't forget to add proper indexes in the table! (which is next step in the fun)


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -