"Create Table" query for MS Access Databases
Posted on 2004-09-02
I've two questions to ask
1 - Can we use the use the "Create table" query to make new tables within our database? Make sure I'm talking about MS Access Database. If we can, then what syntax shall be used to create table n how the datatypes must be defined. Moreover, if I use a field that receives the input string as Integer and it gets out of the integer range, then how we shall arrange the field. In Access we can simply do that by setting the "Field Size" to double n add the no. of decimal places. Hw it shall be used while creating a data field?
2 - Secondly, if the database is already ready, but missed to add one more field within it, then what syntax shall I use to add the missing field in the already exisiting database? Lets say I made a database named "Profile.mdb" containing "FName", "Lname" as basic fields but I need to add one more field within it using the online script. Then I definitely won't update the databse back again to overwrite the past one. What alternate shall be used instead of uploading to add our required fields within the exiting n uploaded database?
Will wait for ur replies. Bye