General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
1. EASIER- i have a generic method that makes a create table statement ( it's actually a rip-off of gendbc.prg with mods for sql server ). to do the alter takes more work. i can do the work, but i don't feel the need when i have a nice way to do it.
2. COLUMN ORDER- i don't usually want my new columns at the end of the table. alter table can't get the new columns in where i want them. plus, my application depends on the columns being in the proper location because my application dynamically creates all my edit forms based on the table structure.
Make sense?
DB
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only