Thursday, January 17, 2008

How to Alter ColumnName in sql server with query..

We are normally using Alter Column Modify command to modify the column defination. But SQL Server does not support it. Rather then then that they are are supporting new syntax Like

"ALTER TABLE ALTER COLUMN"

Here is the syntax for ALTER TABLE command for sql server.

ALTER TABLE table { [ ALTER COLUMN column_name { new_data_type [ ( precision [ , scale ] ) ] [ COLLATE <> ] [ NULL NOT NULL ] {ADD DROP } ROWGUIDCOL } ] ADD { [ <> ] column_name AS computed_column_expression } [ ,...n ] [ WITH CHECK WITH NOCHECK ] ADD { <> } [ ,...n ] DROP { [ CONSTRAINT ] constraint_name COLUMN column } [ ,...n ] { [ WITH CHECK WITH NOCHECK ] CHECK NOCHECK } CONSTRAINT { ALL constraint_name [ ,...n ] } { ENABLE DISABLE } TRIGGER { ALL trigger_name [ ,...n ] } }

If you want more to know about it. Please visit following link at Micorosft sql server developement center.

http://msdn2.microsoft.com/en-us/library/aa275462(SQL.80).aspx
Share:

0 comments:

Post a Comment

Your feedback is very important to me. Please provide your feedback via putting comments.

Support this blog-Buy me a coffee

Buy me a coffeeBuy me a coffee
Search This Blog
Subscribe to my blog

  

My Mvp Profile
Follow us on facebook
Blog Archive
Total Pageviews