Previous Topic: Spell_Macro_Type TableNext Topic: Survey Table


SQL_Script Table

Stores SQL scripts used by the CA SDM applications.

Field

Data Type

Reference

Remarks

del

INTEGER NOT_NULL

 

Deleted flag

0—Active

1—Inactive/marked as deleted

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

sql_desc

STRING 240

 

user title for script

sql_name

STRING 30 S_KEY

 

user name for script

sql_script

STRING 500

 

actual script