Got it

Reserved Keywords For GuassDB(DWS)[L1]

Latest reply: Jan 21, 2022 10:08:02 616 20 13 0 0

Background Information:

SQL(Structured Query Language):

SQL is a language for interacting with databases. It is the standard language for relational database management systems, according to ANSI (American National Standards Institute).

SQL has a number of statements that allow you to do things like:

ü  Data can be queried.

ü  Rows can be added, updated, and deleted.

ü  Objects can be created, replaced, modified, and deleted.

ü  Access to a database and its objects can be restricted.

ü  Maintain the database's consistency and integrity.

SQL is a language that allows you to manage databases and database objects using commands and functions. SQL can also force the rules for data types, expressions, and texts to be implemented. As a result, in addition to SQL syntax, the section "SQL Reference" describes data types, expressions, functions, and operators.

Supported SQL Standards For GaussDB(DWS)  

GaussDB(DWS) is Postgres-XC compliant and supports the following major capabilities by default. 

SQL2: ANSI X3.135-1992, ISO/IEC 9075:1992, SQL-92

SQL3: ISO/IEC 9075:1999, SQL:1999

SQL4: ISO/IEC 9075:2003, SQL:2003

What are Keywords:

For defining, manipulating, and accessing databases, Microsoft SQL Server employs   keywords. The grammar of the Transact-SQL language, which SQL Server uses to parse and understand Transact-SQL statements and batches, includes   keywords. Although using SQL Server   keywords as identifiers and object names in Transact-SQL scripts is syntactically possible, you can only do so by using delimited identifiers.

The following table Is a  lists of SQL Server and GuassDB(DWS)   Reserved keywords that should not be used as identifier in any condition.

 (A-F)

ALL

ANALYSE

ANALYZE

AND

ANY

ARRAY

AS

ASC

ASYMMETRIC

AUTHID

AUTHORIZATION

BINARY

BOTH

BUCKETS

CASE

CAST

CHECK

COLLATE

COLLATION

COLUMN

CONCURRENTLY

CONSTRAINT

CREATE

CROSS

CURRENT_CATALOG

CURRENT_DATE

CURRENT_PATH

CURRENT_ROLE

CURRENT_SCHEMA

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_USER

DEFAULT

DEFERRABLE

DESC

DISTINCT

DO

ELSE

END

EXCEPT

FALSE

 

The above is the list of reserved keywords starting from letter A till F I will be sharing more in the upcoming article.. stay tuned

 

 


  • x
  • convention:

MahMush
Moderator Author Created Dec 20, 2021 06:27:33

  • x
  • convention:

wissal
MVE Created Dec 20, 2021 06:42:01

Important content
View more
  • x
  • convention:

MahMush
MahMush Created Dec 20, 2021 12:46:13 (0) (0)
glad to know you get informative content  
Unicef
MVE Created Dec 20, 2021 06:43:23

Thanks for sharing
View more
  • x
  • convention:

MahMush
MahMush Created Dec 20, 2021 12:54:04 (0) (0)
Happy to know it  
Saqib123
Created Dec 20, 2021 12:33:24

Thanks for sharing Valuable information.
View more
  • x
  • convention:

MahMush
MahMush Created Dec 20, 2021 12:46:39 (0) (0)
please share what you get from it  
faysalji
Author Created Dec 20, 2021 14:15:54

That's informative, thanks for sharing.
View more
  • x
  • convention:

MahMush
MahMush Created Dec 22, 2021 04:12:09 (0) (0)
happy to see your review..must share your thoughts  
hugu
Created Dec 20, 2021 14:17:06

Thanks for sharing
View more
  • x
  • convention:

MahMush
MahMush Created Dec 23, 2021 15:41:27 (0) (0)
thanks to give your feedback  
Anno7
Author Created Dec 21, 2021 08:46:45

completely amazing article..
View more
  • x
  • convention:

MahMush
MahMush Created Dec 22, 2021 04:14:15 (0) (0)
share your experience what you get from it  
Anno7
Anno7 Reply MahMush  Created Dec 22, 2021 04:18:04 (0) (0)
learn new keyword....  
Kashif
HCIE MVE Author Created Jan 8, 2022 19:01:21

good
View more
  • x
  • convention:

MahMush
MahMush Created Jan 9, 2022 08:38:38 (0) (0)
than you for response  
AL_93
Created Jan 15, 2022 06:32:03

Great content, thanks for sharing.
View more
  • x
  • convention:

12
Back to list

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.