What's the maximum number of characters that a tablename
can have?
Answers were Sorted based on User's Feedback
Answer / ankit
A TABLE NAME HAVE 1 TO 30 CHARACTERS IN LENGHT AND MUST BE
UNIQUE WITHIN THE TABLE
| Is This Answer Correct ? | 2 Yes | 0 No |
Which is faster delete or truncate?
How can you display the current date & current time ?
Can you define an Index if the table size less than 10 PAGES?
What is meant by AUTO COMMIT?
What is a lock?
What are the full forms of spufi and dclgen and why are they used?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is role in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is db2 optimizer?
What is copy pending status in db2?
How to restart a DB2 program?