I have a Teradata model, need to have database name as a qualifier to appear before table name in the create table statement. In Forward Engineering, under the table, I checked all the options, but still not seeing the database name as a qualifier, how to do this?
First need to set the database name in the model by right click on the tables, go to properties, and under the database, click the arrow, you can pick up existing database name or create a new one by clicking on the “new” icon. After that go to Actions | Forward Engineer-schema, under the options tab, go to other options, on the right side, check on the box of Qualify Names, preview the ddl script, it will appear as CREATE TABLE [Database name].[table name].