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 |
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: AMDESKINSTANCEThe new table I want to add is called: UserInSystemSo 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. |
|
|
accesser2003
Starting Member
14 Posts |
Posted - 2007-08-11 : 02:18:15
|
But how, would you please give me the full statement.Thanks, |
|
|
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. |
|
|
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" |
|
|
|
|
|