Alter table in MsSsql

Adding a column into Existing Table(Contact)
 ALTER TABLE Contact ADD Phone nvarchar(50) NULL  

Removing a Column from a existing Table
ALTER TABLE Contact DROP COLUMN Phone

Altering Data Type of a column
(phone has the value nvarchar(50) now we like to change it to the varchar(20))
ALTER TABLE Contact ALTER COLUMN Phone varchar(20)

Comments

Post a Comment

Popular posts from this blog

Two dimensional Array into DataTable

string   [,] mdArray = new string   [ 3 , 3 ]{{ "a" , "b" , "c" },{ "d" , "e" , "f" },{ "g" , "h" , "i" }};         ArrayList arList = new ArrayList ();         DataTable table = new DataTable ();        table . Columns . Add ( "C1" );        table . Columns . Add ( "C2" );        table . Columns . Add ( "C3" );         //Multi Dimension Array into DataTable         for ( int outerIndex = 0 ; outerIndex < 3 ; outerIndex ++)         {               DataRow newRow = table . NewRow ();             for ( int innerIndex = 0 ; innerIndex < 3 ; innerIndex ++)             {                newRow [ innerIndex ] = mdArray [ outerIndex , innerIndex...
Read more