a table name can have upto_______ characters including letters,numbers and spaces
Answers
Answer:
A table name can have upto 31 characters including letters,numbers and spaces.
Explanation:
Tables names must respect the following rules:
i) The name can contain up to 31 characters.
ii) It must start with a letter of the alphabet.
iii) It may contain any combination of letters, numbers, spaces and underscores.
iv) The following characters are not allowed in table names (will generate an error in the Structure editor): ( ) + - / * " ; = & | # > < ^ ' { } % DIAMOND (0x00D7), CUBE (0x00B3), SQUARE (0x00B2), PLUS-MINUS (0x00B1)
v) In general, you must avoid any characters that might cause the name to be misinterpreted in 4D or via external languages, such as punctuation marks (commas, colons, etc.)
vi) 4D truncates table names that exceed 31 characters and removes any spaces from the beginning or end of the name.
vii) Do not use the same name for two visible objects. If you use the same name twice, a warning dialog box will inform you that another visible object already has the same name and that the entry is not possible.
viii) Do not use reserved names for naming a table or field. Reserved names include command names (Date, Time, etc), keywords (If, For, etc.) and constants.