Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread CREATE DATABASE that begins with a digit
Sat, Mar 11 2023 5:28 AMPermanent Link

Hendrik Albat

Is it somhow possible to create a database that begins with a digit?
For example:    
CREATE DATABASE "2023 Test"
   PATH 'whatever'
Sat, Mar 11 2023 6:55 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Hendrik


Just tris and it looks like the answer is no. You'll need to put an alpha prefix to the name eg DB2023 Test

Roy Lambert
Sat, Mar 11 2023 9:55 AMPermanent Link

Raul

Team Elevate Team Elevate

<<Roy Lambert wrote:
Hendrik
Just tris and it looks like the answer is no. You'll need to put an alpha prefix to the name eg DB2023 Test
Roy Lambert
>>

And just to add refer to  https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Identifiers

"..."Identifiers cannot begin with a digit and must begin with a valid alphabetic character or underscore (_) ..."

Raul
Image