I would like to ask what is the best solution for this problem:
I am developing an application that could create & modify table definition
in SQL Server. It is like the Data Environment in the Enterprise Manager,
Visual Basic, & the other Visual Development tools under Visual Studio Ent
It is quite complicated if I implement Transact-SQL statements that would
modify individual columns without redefining the entire table. It would take
me time, divulging into the ALTER COLUMN statements and using System Stored
Procedures for the Check and Default constraints. SQL-DMO is out of the
question for the product is to be independent from the Lisencing schemes
from SQL Server.
Is this the correct way?
1. Create a new Table with a temporary name assigned to it.
2. Copy the data into the temporary table.
3. Purge the Old Table
4. Rename the temporary table.
Hope you guys could help me...
Gian U. Uy
*sphere Systems Inc.