How would you configure identities in sybase?



How would you configure identities in sybase?..

Answer / Rjeev Saxena

In Sybase, you can configure identities using the IDENTITY property on a column. To create an identity column, use the following command when creating a table:nCREATE TABLE <table_name> (... , <identity_column> INT IDENTITY (<start_value> [, <increment_value>]) ...)nTo set the starting value and increment for an existing identity column, use ALTER COLUMN...

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Sybase Interview Questions

explain engines?

1 Answers  


What are the advantages that you can get from mainframe connect in sybase?

1 Answers  


How to save space when inserting rows monotonically?

1 Answers  


What is the stored procedure to view current lock and processes respectively?

1 Answers  


How do I configure identities in sybase?

1 Answers  


How to change varchar(m) to varchar(n) in sybase?

1 Answers  


When are stored procedures compiled in sybase?

1 Answers  


How can you change to get the decimal separator as comma instead of the decimal point (.)?

1 Answers  


How do I add a sybase driver to sql developer?

1 Answers  


Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

3 Answers   FIC,


How do you use workspace in sybase?

1 Answers  


How to check database size in sybase iq?

1 Answers  


Categories