Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What RDMS objects are created with the SQL CREATE statements?

April 26, 2017create objects RDMS sql statements

0

Posted

What RDMS objects are created with the SQL CREATE statements?

1 Answer

0

Posted

A1) The SQL CREATE statements are used to create the following objects: STOGROUP A storage group DATABASE A logical collection of tables TABLESPACE An area that stores tables TABLE A data structure organized by a specified columns INDEX An alternate path to a table data VIEW An alternate representation of one or more tables SYNONYM An alternate name for local table or view ALIAS An alternate name for a table definition which may be local or remote, existence or nonexistent