Layton ServiceDesk - FAQ - Database Schema
From Layton Support
(Difference between revisions)
(New page) |
m (Jpainter moved page Database Schema to Layton ServiceDesk - FAQ - Database Schema: Standardised title) |
Revision as of 04:26, 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