Layton ServiceDesk - FAQ - Database Schema

From Layton Support
(Redirected from Database Schema)
Jump to: navigation, search

Btn back up.png 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
Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox