Click here to Skip to main content
15,893,486 members
Search within:


how to get alter table script of existing table?
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
SQL-Server-2008R2
how to get alter table script of existing table
Posted
Add a Solution
Comments
Tomas Takac 19-Feb-15 3:54am    
What do you mean? Alter script to do what? You can get the create script for a table easily in SSMS though.
Suvendu Shekhar Giri 19-Feb-15 7:21am    
why don't you write your own? Afterall, it's you who knows what to ALTER in the table.
Check here SQL ALTER Table
John C Rayan 19-Feb-15 10:51am    
You mean 'Alter To' option is disabled and how to get a change script?
vivvicks 19-Feb-15 23:34pm    
Sql server wizard also help you out.Just right click on table name and in script option u will find out what is required by you
Kuthuparakkal 22-Feb-15 20:45pm    
ALTER TABLE is for existing table, not for the tables to be created in future.

1 solution

go to design view of table, right click you will see the generate change script,

for more detail
http://helpdeskgeek.com/how-to/script-table-as-alter-to-disabled/
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Database - Problem in Executing alter table scripts
How do I alter and modify values to an existing table?
Alter table FOREIGN KEY error
alter an existing table in sql server 2008, add AUTOINCREMENT for existing primary key
Alter existing column type
Alter a table
Alter Table
How to get alter table script in sql server 2008?
Generate Alter script of a table in two diff version.
alter Identity column in existing table Sql Server

Advertise
Privacy
Cookies
Terms of Use
Last Updated 26 Feb 2015
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900