adspace


You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

Answer Posted / Sagar Jain

To add a NOT NULL column to a table in Sybase without using the DEFAULT command, use the ALTER TABLE command as follows:nALTER TABLE <table_name> ADD COLUMN <column_name> <data_type> NOT NULL

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category