[Home]  [Edit this page]  [Recent Changes]  [Special Pages]  [Help
SqlAlter

(SQL) alter

Keyword that can be used to modify a  ?table.

alter table AnyTableName
AnyOperation


/* Add the column 'email' to the table 'people'               */
/* the column 'email' is of data type 'varchar' with 70 chars */
alter table people
add email varchar(70)


Code links



last edited (March 21, 2007) by bilderbikkel, Number of views: 514, Current Rev: 2 (Diff)

[Edit this page]  [Page history]  [What links here]  [Discuss this topic]  [Printer Friendly]  

Members

Username:

Password:


Register
Forgot Password?




Programmers Heaven - for .NET, Java, C/C++ and WEB Developers!
© 1996-2008 Community Networks Ltd. All rights reserved. Reproduction in whole or in part, in any form or medium without express written permission is prohibited. Violators of this policy may be subject to legal action. Please read Terms Of Use and Privacy Statement for more information. Development by Tore Nestenius at .NET Consultant - Synchron Data.