`information_schema.views.view_definition`

mysql

type: LONGTEXT NULL

type: LONGTEXT NOT NULL

5.7

type: NULL

Note:

Definition of the view.

5.1-10.8

type: LONGTEXT NOT NULL

Note:

Definition of the view.

type: LONGBLOB NOT NULL

Note:

The definition of view, which is made by the SELECT statement when the view is created.

4-6.1

type: CHARACTER_DATA NULL

Note:

Query expression defining the view (null if the view is not owned by a currently enabled role)

10-15

type: CHARACTER_DATA

Note:

Query expression defining the view (null if the view is not owned by a currently enabled role)

8.2-9.6

type: unknown

Note:

AS clause used to create the view.

1-21.2

type: NVARCHAR(4000) NULL

Note:

If the length of definition is larger than nvarchar(4000), this column is NULL. Otherwise, this column is the view definition text.