Layton ServiceDesk - FAQ - Database Schema
From Layton Support
(Difference between revisions)
m (Jpainter moved page Database Schema to Layton ServiceDesk - FAQ - Database Schema: Standardised title) |
m (Updated links) |
||
Line 1: | Line 1: | ||
− | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
You can find the database schema in the database itself. It's a System View in the Views folder. This query will list all the columns in all the tables, ordered alphabetically. | You can find the database schema in the database itself. It's a System View in the Views folder. This query will list all the columns in all the tables, ordered alphabetically. | ||
Latest revision as of 04:27, 9 September 2016
You can find the database schema in the database itself. It's a System View in the Views folder. This query will list all the columns in all the tables, ordered alphabetically.
SELECT * FROM INFORMATION_SCHEMA.COLUMNS ORDER BY TABLE_NAME ,COLUMN_NAME