Table of Contents
GET/SET PROPERTY statement
These SQL commands allow get/set value of both system and user-defined properties of such database objects as Engine, Database, Table, Field, Link, Server.
Syntax
get_property : GET PROPERTY props_name_list OF DATABASE | GET PROPERTY props_name_list OF TABLE table_name | GET PROPERTY props_name_list OF FIELD column_reference | GET PROPERTY props_name_list OF LINK link_name | GET PROPERTY props_name_list OF SERVER | GET PROPERTY props_name_list OF CONNECTION | GET PROPERTY props_name_list set_property : SET PROPERTY props_name_list OF DATABASE TO value_list | SET PROPERTY props_name_list OF TABLE table_name TO value_list | SET PROPERTY props_name_list OF FIELD column_reference TO value_list | SET PROPERTY props_name_list OF LINK link_name TO value_list | SET PROPERTY props_name_list OF SERVER TO value_list | SET PROPERTY props_name_list OF CONNECTION TO value_list | SET PROPERTY props_name_list TO value_list props_name_list : property_name, ... values_list : value_elem, ... value_elem : character_string_literal | signed_numeric_literal | TRUE | FALSE | NULL
Description
Let's note first of all that these SQL commands can be applied to objects of 3 types:
- Valentina Engine - parameters of engine are not stored at any place, so they are runtime only.
- Database, Table, Link, Field - description of these objects is stored into system tables.
- SERVER - parameters of Valentina Server are stored into ini file.