Max sizes

Hi, I need to know that maximum size for table names , column names and schema names for Informix. And has it changed over vesions.? Actaully I am loking for the same for SQL server and sybase too. Thanks Dimple

IBM Employee <dimple@us.ibm.com> writes: > Hi, > I need to know that maximum size for table names , column names and > schema names for Informix. And has it changed over vesions.? > > Actaully I am loking for the same for SQL server and sybase too. So you'r saying IBM don't track their competitors? Or is the information to hard to find? Thomas

Dimple, It looks like the Informix folks aren't going to help you out, but I can give you the answers for Sybase ASA (not ASE) v7. Identifiers consist of any string of alphabetic characters or digits. The first character of an identifier must be an alphabetic character, not a digit. Alternatively, any string of characters can be used as an identifier by enclosing it in quotation marks ("double quotes") as long as the QUOTED_IDENTIFIER database option is set to ON. The underscore character (_), at sign (@), number sign (#), and dollar sign ($) are considered alphabetic characters. The database collation sequence dictates which characters are considered alphabetic or digit characters. A quotation mark inside the identifier is represented by two quotation marks in a row. Identifiers have a maximum length of 128 bytes. Database size 12 files per database. For each file, the largest file allowed by operating system and file system. Field size 2 GB File size (FAT 12) 16 MB File size (FAT 16) 2 GB File size (FAT 32) 4 GB File size (NTFS, HP-UX 11.0 and later, Solaris 2.6 and later) 256 GB (for 1K pages) 512 GB (for 2K pages) 1 TB (for 4K pages) File size (all other platforms and file systems) 2 GB Maximum index entry size No limit Number of Databases per server 255 Number of columns per table 999 (using 4K pages) Number of indexes The maximum number of indexes per table is based on the database page size: 4K or less 2048 indexes 8K 1024 indexes 16K 512 indexes 32K 256 indexes Number of rows per database Limited by file size Number of rows per table Limited by file size Number of tables per database 2^32 - 1 (4294967295) Number of tables referenced per transaction No limit Row size Limited by file size Table size Maximum file size. User-created indexes for the table can be stored separately from the table. If you have additional questions about ASA, you should visit sybase.public.sqlanywhere.general Does DB2 still have the 18 character limit? In article <3A130BD5.BE876E86@us.ibm.com>, IBM Employee <dimple@us.ibm.com> wrote: > Hi, > I need to know that maximum size for table names , column names and > schema names for Informix. And has it changed over vesions.? > > Actaully I am loking for the same for SQL server and sybase too. > > Thanks > Dimple > > Sent via Deja.com http://www.deja.com/ Before you buy.