Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spinoza
Starting Member
49 Posts |
 Posted - 2006-01-25 : 10:48:57
|
| I have created new columns fields in a table using EManager. However, I am wondering Which command do we use to create columns through the analyser??? Is it the same like the "Insert into"? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-25 : 11:15:36
|
| you probably confuse me with someone else...But in any case thank you very much...But I aggre with that...Memory is like a woman... it is very easy to forget her :) |
 |
|
|
Vatsan
Starting Member
7 Posts |
Posted - 2006-01-25 : 15:06:40
|
| EManager makes things simple if the change has to be done only once. If we have to do some routine JOB then we can go for SQL used in procedures.Try using the following syntax to add a new column to your existing Table.SYNTAX:"ALTER TABLE <table name> ADD <column name> <datatype>"EXAMPLE:ALTER TABLE customer ADD customer_region varchar(30) |
|
|
|
|
|
|
Creating a new column in a Table