Another question, can I create a catalog? Thanks.
Bin On Wed, Sep 13, 2017 at 10:18 AM, Bin Lin <[email protected]> wrote: > 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 >> > >
