I'm making an effort to do work development work inside Mongoose/CSI as if I was in the cloud. I'm working on a project now where it makes sense to have an integer based ID for records. Normally, I'd use SSMS to alter/create the table and add AUTO INCREMENT to the field. Simple example:
CREATE TABLE Persons (
Personid int NOT NULL AUTO_INCREMENT,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (Personid)
);
I can see that I can do SQL table creation from inside CSI but it appears to be limited. Is there a way from inside CSI to create an auto increment column in a table definition? If not, what is the recommended way to have an ID that auto increments based on the next record.
