Groups | Blog | Home
all groups > sql server (alternate) > march 2004 >

sql server (alternate) : creating a database with sql


William Kossack
3/31/2004 1:23:15 PM
Can I create a new database using sql from outside sqlserver?

for example can I send sql code to the server to create a database
William Kossack
3/31/2004 1:46:55 PM
thanks

now I just need to be able to do the same thing in access

[quoted text, click to view]
DHatheway
3/31/2004 2:29:30 PM
Sure. MS SQL Server implements the CREATE DATABASE command. You can look
up the exact syntax in SQL Server Books On-Line.

[quoted text, click to view]

David Portas
3/31/2004 9:30:26 PM
CREATE DATABASE NewDatabaseName

See Books Online for the full details of the CREATE DATABASE statement.

Does that answer your question?

--
David Portas
SQL Server MVP
--

Erland Sommarskog
3/31/2004 10:47:57 PM
William Kossack (kossackw@njc.org) writes:
[quoted text, click to view]

That will be comp.databases.ms-access. Or maybe Access comes with
some online documetion you can try. SQL Server does this too, by
the way.

No, I have no idea how you create a database in Access; never used it.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
AddThis Social Bookmark Button