Create a new database

Source: Internet
Author: User
Tags character set command line interbase connect requires window create database
Create | data | database and Desktop Database (in the case of a real database, it should be called a data table), the InterBase database exists only one. GDB is the "large file" of the extension, which packs all the data tables, indexes, stored procedures, views, triggers, exceptions, and so on. Such a database for data maintenance and backup, etc. are greatly simplified.
To create a database, first you have to install InterBase, the following discussion is InterBase 6 version of the discussion, no interbase 6, please download the site in the software download or to the relevant data site downloaded a InterBase 6 to install. The default installation path for InterBase 6 is "C:\Program files\borland\interbase".
Open the Start-> program-> "InterBase"-> "Ibconsole".
You'll see the ibconsole operation main interface:

Action steps are as follows:
1: Database server login.
A: Double-click InterBase Servers or select InterBase Servers Press the right mouse button to select the Register menu and open the Register Server and Connect window.
B: If you are logged on locally, select Local server within the Server information page. Enter your username and correct password in the Login information page. The default user name for InterBase is SYSDBA, and the password is: masterkey (note password sensitivity).
C: If you are logged on to a remote server, select Romote Server in the server information page, unlike local server, server Name, Netword Protocol, and Alias Name becomes optional and requires user to fill out. (such as: Server Name is set to 3hsoft.) Network Protocol Select Tcp/ip,alias Name we set to Test. In which the Login information page operates in the same above B.
2: Create the Database A: After successfully logging on to the server, open the local server in the left window of the ibconsole (assuming we are logged on as a native server method).
B: Select the Databases option, press the right mouse button, the Register and CREATE database two options menu, because we are here to create a database, so we choose the Create a DB menu, pop-up create database Window.
C: Fill in the alias of the database in the alias in the Create Database window. such as: Test
D: In Filename under File (s) page, fill in the name of the data you want to create, this database name must contain the correct path. such as: (E:/3hsot/application/book/test/extradata/test.gdb. )
E: If you are creating a database on the network, you will have to add the name of the server. such as: 3hsot:g:\application\book\test\test.gdb. Different communication protocols are written in a slightly different way. A:TCP: Server Name: Path
B:netbeui: \ \ server name \ Path
C:spx: Server name @ path
Note
The path here refers to the absolute path of the server, not to the server's mapping path through the local PC. Many beginners connect to a InterBase server in parallel, where the path (and also the communication protocol) is wrong. F:options option A: Select Page size, general selection 4096. The size of Page size sometimes directly affects the access speed of the database.
B: Set the default Character set, which sets the database language characters, which are generally set to none.
C: Set up SQL dialect. If you want to create a database that needs to be compatible with older versions of InterBase, set the value to 1. Instead, set to 3.
G: Click the "OK" button and fix it.

H: Of course, you can also use the command line to create a database, but this requires more proficiency in SQL statements, such as to create the same database above, open the Interactive SQL window, write the following name and execute it: Create DATABASE ' e:/3hsot/ Application/book/test/extradata/test.gdb ' page_size 4096; In the later chapters, I'll focus on some of the methods and techniques used to Create database names.
3: Back to the Ibconsole main window, you can see the database you just created Test, but the contents are empty, because you have not created a table, view, storage process, etc., this is only a head open, I hope it is a good head.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.