Hi,
 
I'm logged in with dbc user.
I'm ALTERing a table to add Foreign Key Constraint with Following statement
ALTER TABLE testdb.Master2 ADD CONSTRAINT fk_Master1 FOREIGN KEY (Master1ID) REFERENCES testdb.Master1(Master1ID);
its works fine.
But when i write this in a procedure

Hi,
 
I want to Update a table. But before that i want disable foreign key\check Constraint\Unique Key on some tables.
After update, i want to enable those disables constraint again.
 
Can you please tell me how can i do that.
 
Parth

Hi All,
I have a table that has a composite key defined on 2 columns.
These column are not a part of primary index.
The table contains data.
I am trying to drop primary key using the following command and getting a systax error :
alter table person_mst drop primary key (id,name);

Hi,
I'm new to Teradata and have a question on creating a table with a CPPI.
I have a table with a few hundered million rows. I want to create partitioning on a column called SAP_CODE whose structure is always four digits. The first digit is alphanumeric the last 3 digits are numeric, e.g. S001, M123, Z012.

Hi,

Is there any way to partition directly on a small (ie. CHAR(3)) character column, without defining a CASE_N or RANGE_N for the column (ie. partition on all unique values of the column)?

Hi,

I need to get the following information of all table indices of a table with the JDBC 'getIndexInfo()' method
to be able to create a similar table but with modified indices.

- The index number
- The index column name of the index number
- The index column position of the index number
- The unique index flag of the index number
- Primary or Secondary index flag of the index number

The first 4 are returned nicely by the 'getIndexInfo()' method.

But I'cant see any information returned by the 'getIndexInfo()' method that
looks like a 'Primary or Secondary Index' flag.