SQL

Unfold Hierarchy number Tags Values

SQL

1 Examples

1.1.1 Names of user tables

SELECT TABLENAME FROM SYS.SYSTABLES WHERE TABLETYPE='T'

1.1.2 Information of user tables

SELECT * FROM SYS.SYSTABLES WHERE TABLETYPE='T'

1.1.3 Names of system tables

SELECT TABLENAME FROM SYS.SYSTABLES WHERE TABLETYPE='S'

1.1.4 Information of system tables

SELECT * FROM SYS.SYSTABLES WHERE TABLETYPE='S'

1.1.5 Names of views

SELECT TABLENAME FROM SYS.SYSTABLES WHERE TABLETYPE='V'

1.1.6 Information of views

SELECT * FROM SYS.SYSTABLES WHERE TABLETYPE='V'

1.1.7 Names and types of table columns

SELECT columnname, columndatatype FROM SYS.SYSTABLES t, SYS.SYSCOLUMNS c where t.TABLEID=c.REFERENCEID AND tablename='TREE' order by columnnumber

1.1.8 Information of table columns

SELECT c.* FROM SYS.SYSTABLES t, SYS.SYSCOLUMNS c where t.TABLEID=c.REFERENCEID AND tablename='TREE' order by columnnumber

1.1.9 Names of table indices

SELECT CONGLOMERATENAME FROM SYS.SYSTABLES t, SYS.SYSCONGLOMERATES c where t.TABLEID=c.TABLEID AND tablename='TREE'

1.1.10 Information of table indices

SELECT c.* FROM SYS.SYSTABLES t, SYS.SYSCONGLOMERATES c where t.TABLEID=c.TABLEID AND tablename='TREE'

1.2 Query tables of database

1.2.1 Range of rows

SELECT * FROM visit_history OFFSET 2 ROWS FETCH NEXT 50 ROWS ONLY

1.2.2 Maximum rows

SELECT * FROM visit_history FETCH FIRST 300 ROWS ONLY

1.2.3 First row

SELECT * FROM visit_history FETCH FIRST ROW ONLY

1.2.4 Conditions of query

SELECT * FROM visit_history WHERE file_type > 1 OR data_more like '%fxml%'

1.2.5 Count

SELECT count(file_type) as count FROM visit_history WHERE file_type > 0 AND last_visit_time BETWEEN '2022-03-11 00:00:00.000' AND '2022-03-18 13:09:41.000'

1.2.6 Mode

SELECT file_type, count(file_type) AS mode FROM visit_history GROUP BY file_type ORDER BY mode DESC FETCH FIRST ROW ONLY

* Links and controls may be unresponsive when html page is editable.