Got it. Thank you. On Tue, Sep 12, 2017 at 6:03 PM, Anoop Sharma <[email protected]> wrote:
> to add to that. > > in Trafodion, a 'database' equivalent is a schema. > And multiple schemas can be created in a catalog > which is 'Trafodion'. This is to keep with ansi 3-part > naming scheme for every object. > > One can also do: create schema trafodion.s; > or 'get schemas in catalog trafodion'. > > When you do 'get schemas' or 'show schema' (from trafci), > there will also be multiple internal system 'schemas' that will show up. > These schemas (they start and end with an underscore) are reserved > and not to be used for user objects. > > anoop > > -----Original Message----- > From: Liu, Yuan (Yuan) [mailto:[email protected]] > Sent: Tuesday, September 12, 2017 5:59 PM > To: [email protected] > Subject: RE: create database > > Please use below syntax, > > Create schema test_schema; --create schema > Get schemas; --get all schemas; > Show schema; --show current schema > Set schema test_schema; --set schema to specific schema > > > Best regards, > Yuan > > -----Original Message----- > From: Bin Lin [mailto:[email protected]] > Sent: Wednesday, September 13, 2017 8:53 AM > To: [email protected] > Subject: create database > > Hi there, > > I am trying to create a database in trafci interactive mode. I use the > command `create database mydatabase`. But it failed. I couldn't find > examples online about how to create a database and how to check all > existing databases. > > Thank you for your information. > > Best, > Bin >
