Create a database script?


Create a an alter command to add a field to a table in sql 2005.
mathieu_cuprykAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
ALTER TABLE <TableName>
ADD newField Varchar(100)
0
 
cforantCommented:
ALTER TABLE table_name ADD column_name column-definition;

For example:
ALTER TABLE supplier ADD supplier_name  varchar2(50);

0
 
mathieu_cuprykAuthor Commented:
First come first serve. Thanks guys.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.