November 4, 2002 at 12:30 pm
Hi,
I wonder if there is a way I can modified the current design of a table in EM and save it under a new table name? Like I already have table A; I open the design of table A, add a new column and save it as table B?
Thanks.
November 4, 2002 at 12:35 pm
Not that I am aware of. Of course you could always script out TABLE A and modify the script to create TABLE B.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 4, 2002 at 1:07 pm
It seems easy to me in QA but not to my developers. EM is their favorite.
Thanks.
November 4, 2002 at 1:12 pm
Make the changes and then click the Save Script button. The third icon from the left.
Save this and run it. Change the name of the table.
Steve Jones
November 4, 2002 at 1:13 pm
Of course the GUI is easy, but the reality everything can't be done with the GUI. If the developers can't be trained to understand TSQL commands, then I might ask how valuable are they as developers?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
November 4, 2002 at 1:27 pm
A hearty AMEN to Greg Larsen.....
November 4, 2002 at 3:18 pm
Lack of T-SQL skills seen often with ASP programmers from the dot com era. Sorry if others feel ofended. I seen lot of things can be done in SQL such as CHECK, TRIGGER, JOB, etc. are coded in ASP. It generates unnecessary traffic and more load on SQL.
November 4, 2002 at 3:41 pm
Wirth what Steve stated just to add a bit. Close the table, right click on the table in EM and do copy. Then post the table DDL into QA, rename the table and any constraints or named indexes so they don't cause error.
And I agree, if a developer does not know how to use all the tools they are supplied then they really are in need of a good talking with.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply