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:40] dlm [Troubleshooting] |
normal_processing_steps [2021/02/02 20:43] 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 | + | 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.)<br /><br /> | + | (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). <br /><br /> | :*In the Novoschema editor, add the new column with the exact same name – (New_field in previous step). <br /><br /> | ||
:*Save the schema and generate the code, Uncheck ‘Generate Primary Table’. | :*Save the schema and generate the code, Uncheck ‘Generate Primary Table’. |