Layton ServiceDesk - FAQ - Database Schema

Revision as of 05:43, 27 April 2015

Back to Contents

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