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 |
|
asfia
Starting Member
2 Posts |
 Posted - 2007-06-05 : 07:07:37
|
| hi..i want to know how to create table while specifying the database name..the syntax given in the help is thisCREATE TABLE [ database_name.[ owner ] . | owner. ] table_name but i cant seem to do it.. it always generates an error whenever i give my database name.. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-05 : 07:11:04
|
| This maybe?USE database_nameCREATE TABLE ...Kristen |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-05 : 07:12:43
|
quote:
Originally posted by Kristen
This maybe?USE database_nameGOCREATE TABLE ...Kristen
Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
asfia
Starting Member
2 Posts |
Posted - 2007-06-05 : 07:26:10
|
| thanks |
|
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2007-06-05 : 08:29:50
|
CREATE TABLE Northwind.dbo.MyTestTable(Col1 int)Beauty is in the eyes of the beerholder  |
|
|
|
|
|
|
craete table syntax