column_value % modulo_value --> is a modulo operator

% 2 [modulo 2] is generally used to check if a given number is even or odd

% 10 [modulo 10] is generally used...

This has happened with me in the past as well. Is there a way out to get over this issue permanently?

Thanks in advance.

Oh...got is Thanks!

both catalog view(sys schema) and information_schema views can be used.

i would execute in the following fashion

1. move all the table definitions into new schema

2. copy data over new schema (explorw bcp option)

3. create FKs and Indexes