DDL SQL and Install script

 The Alinous-Core supports Data Definition Language(DDL).

Install Script

install script

 If you create install script under the ALINOUS_HOME, the content assist for the database table and column become available.

The Install Script is to make tables and indexes when newly install web application. By preparing this, you can install your web application soon, so it support your software testing process.

CREATE TABLE

 Create a new table. If the table exists, exception is thrown. You can check if the table exists or not bySql.TableExists() function.

DROP TABLE

 Drop the table.

CREATE INDEX

 Create an index. This sentence also should be written in the install script.

DROP INDEX

 Drop an index.

ALTER TABLE

 Alter the table. This is not used in the normal install script. Use this when the application upgrade.


Go to Top