Creating a database in Microsoft SQL Server or MSDE

Previous chapterNext chapter Show allShow all    Hide allHide all

You also can create a database with the command interpreter, if no user interface for your SQL server is available.

Start a new instance of the command prompt (cmd.exe).

In the command interpreter the tool osql.exe can be started with the following instruction.

osql.exe -E -S computer name / instance name

The instructions for creating a database:

1> CREATE DATABASE database name

2> GO

Database name

any name for the database. e.g.: IPA

With 'exit' the program osql.exe is closed.

The table in the database is automatically created on the first start of the Runtime by zenon.