Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1645#discussion_r202881043
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -390,25 +390,27 @@ alter-action is:
column-definition is:
column-name data-type
- ([DEFAULT default]
- [[constraint constraint-name] column-constraint])
+ [[DEFAULT default]
+ [[constraint constraint-name] column-constraint]]
data-type is:
char[acter] [(length)[characters]]
- [CHARACTER SET char-set-name]
- [UPSHIFT] [[not] casespecific]
- | char[acter] varying (length)
- [character set char-set-name]
- [upshift] [[not] casespecific]
- | varchar (length) [character set char-set-name]
- [upshift] [[not] casespecific]
- | varchar2 (length) [character set char-set-name]
- [upshift] [[not] casespecific]
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+ | char[acter] varying (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+ | varchar (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+ | varchar2 (length [characters])
+ [CHARACTER SET char-set-name]
+ [UPSHIFT] [[NOT] CASESPECIFIC]
+ | nchar [length [characters]]
--- End diff --
`length [characters]` is optional.

---
|