This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
normal_processing_steps [2021/02/02 20:43] dlm [Suggested Ways to Add a Column to a Schema That Already Exists] |
normal_processing_steps [2021/02/02 20:48] dlm [Suggested Ways to Add a Column to a Schema That Already Exists] |
||
---|---|---|---|
Line 25: | Line 25: | ||
* In SQL, execute a new query against the main database: | * In SQL, execute a new query against the main database: | ||
- | ALTER TABLE dbo.TABLENAME | + | < |
- | ADD New_field varchar(20) | + | ADD New_field varchar(20) |
- | (This step can also be done by right-clicking on the SQL table and using Design.) | + | This step can also be done by right-clicking on the SQL table and using Design. |
- | :*In the Novoschema editor, add the new column with the exact same name – (New_field in previous step). | + | |
- | :*Save the schema and generate the code, Uncheck ‘Generate Primary Table’. | + | * Save the schema and generate the code, Uncheck ‘Generate Primary Table’. |
- | :*On UNIX copy to clipboard, paste into SQL, verify the first thing is [Use…_TRIGGER], | + | * On UNIX copy to clipboard, paste into SQL, verify the first thing is [Use…_TRIGGER], |
- | :*On Windows click the " | + | * On Windows click the " |
- | :*Verify there are no records in BCI.QUARANTINE that were created between the alter table and schema editor change steps. | + | *Verify there are no records in BCI.QUARANTINE that were created between the alter table and schema editor change steps. |
- | :*LOAD.BCI.ACTION for any records that need the new column. | + | *[[load_bci.action|LOAD.BCI.ACTION]] for any records that need the new column. |