Correct Syntactic Descriptions of Data Types in CREATE TABLE Statement
Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/dfa4c2e8 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/dfa4c2e8 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/dfa4c2e8 Branch: refs/heads/master Commit: dfa4c2e81ed39f3ae3a010db67c564968e1f8dfe Parents: 1fd8407 Author: liu.yu <[email protected]> Authored: Fri Jul 13 16:25:28 2018 +0800 Committer: liu.yu <[email protected]> Committed: Fri Jul 13 16:25:28 2018 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/sql_statements.adoc | 24 ++++++++++++-------- 1 file changed, 14 insertions(+), 10 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/dfa4c2e8/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc index ced4e6d..88bd40a 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc @@ -2963,18 +2963,22 @@ column-definition is: <<< ``` data-type is: - char[acter] [(length [characters])] - [character set char-set-name] - [upshift] [[not]casespecific] + char[acter] [length [characters]] + [character set char-set-name] + [upshift] [[not]casespecific] | char[acter] varying (length [characters]) - [character set char-set-name] - [upshift] [[not]casespecific] - | varchar (length) [character set char-set-name] + [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]] [upshift] [[not]casespecific] - | varchar2 (length) [character set char-set-name] - [upshift] [[not]casespecific] - | nchar (length) [characters] [upshift] [[not]casespecific] - | nchar varying(length [characters]) [upshift] [[not] casespecific] + | nchar varying (length [characters]) + [upshift] [[not] casespecific] | numeric [(precision [,scale])] [signed|unsigned] | smallint [signed|unsigned] | int[eger] [signed|unsigned]
