Wednesday, March 7, 2012

does anyone know how to modify table structure in sql server management console(2005)? tha

does anyone know how to modify table structure in sql server management console(2005)? thanksHi,
If you open Management Studio and drill down until you reach the table you want to modify, you can click the + image to see table structure.
If expand the columns, you will see the list of columns in that table. You can add a new column by right click an selecting New Column. Or modify one by right-clicking over that column and selecting modify option in the context menu.
You can also make modification as such for contraints, key, etc
Eralper
http://www.kodyaz.com

No comments:

Post a Comment