i have a question for you initially i created table Test.Student. CREATE TABLE [Test].[STUDENT]( [ID] [ int ] NULL , [ Name ] [nvarchar](50) NULL ) ON [ PRIMARY ] GO Then i Added a new coloumn Class i need to take the cretae script of the table using alter without droping the table.. help

Hello, To alter any table with the query without dropping the table the syntax for altering a table is: ALTER TABLE tableName ADD column1_name column_definition ADD column2_name column_definition As you want to add a column "class" you can use the query: ALTER TABLE [Test].[STUDENT]( ADD [Class] [nvarchar](50) NULL ) GO Hope this helps!