This sample contains examples of solidDB SQL scripts for creating tables, indexes, roles, users, and stored procedures.
The sample files are located in the soliddb-installdir\samples\sql directory. For general information about running the samples, see Samples.
The sample consists of the following two SQL scripts:
▪ sample.sql: a script that runs table, index, role, and user creation examples,
▪ procedur.sql: a script that runs a couple of stored procedure creation examples. For more stored procedure examples, see Stored procedures and ODBC sample.
sample.sql
The script completes the following actions:
1 Create two tables in the database.
2 Create and update a number of users and associated passwords.
3 Create two roles, associate the roles with the tables and the users, and change some of the user rights and role associations.
4 Modify the tables and add and remove unique and non-unique indexes.
procedur.sql
This script completes the following actions:
1 Create and run a stored procedure that does simple calculations,
2 Create and run a stored procedure that reports on database backups.
Running the sample
Run the runme script (runme.bat in Windows), which starts a solidDB database, and then runs the SQL scripts one after the other. Alternatively, you can run the SQL scripts individually by using solsql with an existing solidDB database, see solidDB SQL Editor (solsql).