Creating a database in Microsoft SQL Server or MSDE
|Show all Hide 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
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.