Example: Creating a Profile with Default Storage - Teradata VantageCloud Lake

This statement creates the profile profile1 with default storage TD_OFSSTORAGE and an override option:

CREATE PROFILE profile1 AS
  DEFAULT STORAGE TD_OFSSTORAGE OVERRIDE ON ERROR;

If user1 has profile1, the following statements are equivalent. Both create the table user1.tb1 as an Object File System table by default. Because an Object File System table cannot have a primary index, the second statement ignores the PRIMARY INDEX clause.

CREATE TABLE user1.tb1 (a INT, b INT) NO PRIMARY INDEX;

CREATE TABLE user1.tb1 (a INT, b INT) PRIMARY INDEX (a);