http://www.valentina-db.com/dokuwiki/ 2010-03-11T01:43:18+01:00 http://www.valentina-db.com/dokuwiki/ http://www.valentina-db.com/dokuwiki/lib/images/favicon.ico text/html 2010-03-06T23:57:42+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:properties:properties&rev=1267916262&do=diff Articles * Properties of Database Objects SQL Commands To work with properties of a schema object you can use the following SQL commands: * GET/SET PROPERTY statement * SHOW PROPERTIES Valentina Engine Properties Exists the set of system properties at Valentina engine level. They are runtime properties. You can GET and SET their values usually to change behavior of Valentina engine. text/html 2010-03-06T23:53:29+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:properties:get_set_property&rev=1267916009&do=diff 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 | G… text/html 2010-03-06T23:32:31+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_status_database&rev=1267914751&do=diff This command shows statistic parameters of the specified Valentina Database. If the database name is absent, then the active database is used. Syntax SHOW STATUS {OF|FOR} DATABASE [name] Result Columns fld_name The name of STATUS parameter. text/html 2010-03-06T23:32:16+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_status_field&rev=1267914736&do=diff This command shows statistic parameters of the specified Field. Syntax SHOW STATUS {OF|FOR} {FIELD|COLUMN} table_name.field_name Result Columns fld_name The name of STATUS parameter. fld_value The value of STATUS parameter. fld_level text/html 2010-03-06T23:31:57+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_status_index&rev=1267914717&do=diff This command shows statistic parameters of the specified Valentina Link. Syntax SHOW STATUS {OF|FOR} INDEX name Result Columns fld_name The name of STATUS parameter. fld_value The value of STATUS parameter. fld_level The level of STATUS parameter. text/html 2010-03-06T23:31:36+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_status_link&rev=1267914696&do=diff This command shows statistic parameters of the specified Valentina Link. Syntax SHOW STATUS {OF|FOR} LINK name Result Columns fld_name The name of STATUS parameter. fld_value The value of STATUS parameter. fld_level The level of STATUS parameter. text/html 2010-03-06T23:31:12+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_status_server&rev=1267914672&do=diff This command shows statistic parameters of the Valentina Server. Syntax SHOW STATUS {OF|FOR} SERVER Result Columns fld_name The name of STATUS parameter. fld_value The value of STATUS parameter. fld_level The level of STATUS parameter. text/html 2010-03-06T23:30:54+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_status_table&rev=1267914654&do=diff This command shows statistic parameters of the specified Valentina Table. Syntax SHOW STATUS {OF|FOR} TABLE name Result Columns fld_name The name of STATUS parameter. fld_value The value of STATUS parameter. fld_level The level of STATUS parameter. text/html 2010-03-06T23:29:56+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_table&rev=1267914596&do=diff SHOW TABLES statement lists non-TEMPORARY tables and views of a database. Syntax SHOW TABLES [{FROM|OF} db_name] Examples SHOW TABLES -- this query selects only TABLEs but not VIEWs. SELECT * FROM (SHOW TABLES) WHERE type = 'TABLE' Result Columns fld_type text/html 2010-03-06T23:29:19+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_links&rev=1267914559&do=diff [NEW in 3.3] SHOW LINKS statement lists non-TEMPORARY links of a database. Syntax SHOW LINKS [{FROM|OF} table_name] [{FROM|OF} db_name] Result Columns * fld_id The unique ID of link. * fld_link The name of link. * fld_kind text/html 2010-03-06T23:28:52+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_events&rev=1267914532&do=diff [NEW in 3.0] The SHOW EVENTS statement is used to list events of the Scheduler of a Valentina Server. Result of this statement is Cursor as with SELECT statement. Syntax SHOW EVENTS {FROM|OF} db_name Result Columns fld_name The name of the event. text/html 2010-03-06T23:28:27+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_columns&rev=1267914507&do=diff SHOW COLUMNS displays information about the columns in a given table or view. Syntax SHOW COLUMNS {FROM|OF} table_name [{FROM|OF} db_name] Result Columns * fld_name The name of the column. * fld_type The type of the field. * fld_id text/html 2010-03-06T23:26:03+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_triggers&rev=1267914363&do=diff [NEW in 3.0] SHOW TRIGGERS statement is used to list the triggers of the database. The result of this statement is a Cursor (VCursor) as with the SELECT statement. Syntax SHOW TRIGGERS [{FROM|OF} table_name] [{FROM|OF} db_name] Result Columns * fld_trigger text/html 2010-03-06T23:16:24+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:reference&rev=1267913784&do=diff A reference of Valentina SQL, an implementation of SQL 1992-2003 with extensions in the Valentina engine. SQL Grammar * Lexical Tokens * Grammar * Keywords Schema Definition Commands * CREATE TABLE statement * CREATE INDEX statement * CREATE LINK statement * CREATE TRIGGER statement - NEW in 3.0 * CREATE VIEW statement - NEW in 3.0 text/html 2010-03-06T22:38:46+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_status_kernel&rev=1267911526&do=diff This command shows statistic parameters of the Valentina Kernel. Syntax SHOW STATUS Result Columns fld_name The name of STATUS parameter. fld_value The value of STATUS parameter. fld_level The level of STATUS parameter. STATUS PARAMETERS CACHE DIRTY PAGES text/html 2010-03-06T19:29:11+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_properties_table&rev=1267900151&do=diff This command shows properties of the specified Valentina Table. Syntax SHOW PROPERTIES OF TABLE table_name Result Table Columns You can read description of the result table columns here. List of Properties You can find detailed description of a Valentina Table properties here . text/html 2010-03-06T19:28:33+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_properties_server&rev=1267900113&do=diff This command shows properties of the specified Valentina Server. Syntax SHOW PROPERTIES OF SERVER Result Table Columns You can read description of the result table columns here. List of Properties You can find detailed description of a Valentina Server properties here . text/html 2010-03-06T19:28:03+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_properties_link&rev=1267900083&do=diff This command shows properties of the specified Valentina Link. Syntax SHOW PROPERTIES OF LINK link_name Result Table Columns You can read description of the result table columns here. List of Properties You can find detailed description of a Valentina Link properties here . text/html 2010-03-06T19:27:27+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_properties_kernel&rev=1267900047&do=diff This command shows properties of the Valentina Engine. Syntax SHOW PROPERTIES Result Table Columns You can read description of the result table columns here. List of Properties You can find detailed description of the Valentina Engine properties here . text/html 2010-03-06T19:27:09+01:00 Ruslan Zasukhin http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:show:show_properties_field&rev=1267900029&do=diff This command shows properties of the specified field. Syntax SHOW PROPERTIES OF FIELD column_reference Result Table Columns You can read description of the result table columns here. List of Properties You can find detailed description of a field here .