Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create db script 1

Status
Not open for further replies.

hoctro

Technical User
Mar 29, 2001
34
US
Hi
Does anyone have a sample script for creating database ??
thanks
 
Hiya,

Creating a database is fairly simple.

The syntax is CREATE DATABASE (database name)

You can add options, such as "WITH LOG ON" and name the segment where you want your transaction log help.

For more information, use an Internet search engine and look for "SQL CREATE DATABASE" and you should find some useful pages.

Tim
 
hi,

this might help:

create database database_name
[on {default | database_device} [= size]
[, database_device [= size]...]
[log on database_device [ = size ]
[, database_device [= size]]...]
[with override]
[for load]

qyllr

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top