Re: Add a coulm in a table, after a specific column
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 31 Oct 2007 19:40:53 +0100
On Wed, 31 Oct 2007 16:56:29 +0100, D. wrote:
You can use SSMS to generate a script for this (that is if you make the
change via the graphical interface in SSMS). This option is available
through Generate Change Script in the Table Designer menu or if you
right-click the table editor.
Thanks!!!
But please do check, double-check, and triple-check the script before
executing it on a live server. There have historically been some serious
flaws in the scripted code used, that might result in losing all your
data if you are unlucky. Maybe things have changed since the last time I
looked, but I'd never run a script generated by Enterprise Manager or
SQL Server Management Studio without prior minute inspection!
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.
- References:
- Add a coulm in a table, after a specific column
- From: D.
- Re: Add a coulm in a table, after a specific column
- From: Plamen Ratchev
- Re: Add a coulm in a table, after a specific column
- From: D.
- Add a coulm in a table, after a specific column
- Prev by Date: Re: some error in table definition
- Next by Date: Help with SQL query?
- Previous by thread: Re: Add a coulm in a table, after a specific column
- Next by thread: Help with SQL query?
- Index(es):
Relevant Pages
|
