1. Categories >> Software >> Databases >> Sybase
  2. Suggest New Category

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

Question Posted / prem shankar


You need to add a notnull column in a table by using alter command (without using default command). ..

Answer / 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

More Sybase Interview Questions

You need to multiply all values of a single column. How would you do that?

1 Answers  

What causes re-resolution of a stored procedure in sybase?

1 Answers  

Explain procedure cache and data cache in sybase.

1 Answers  

Explain about the mainframe connect tools from sybase?

1 Answers  

Compare in and exists?

1 Answers  

What is the role of replication server in sybase?

1 Answers  

What is rollback trigger in a trigger?

1 Answers  

List different types of locks in sybase?

1 Answers  

Explain relationship between jdbc and sybase.

1 Answers  

How to pad with leading zeros an int or smallint in sybase?

1 Answers  

What is sybase infomaker?

1 Answers  

What is sybase? What are its important features?

1 Answers  

For more Sybase Interview Questions Click Here
Categories