- Name length of a column (charters)?
- Name length of a table (charters)?
- Max. number of columns per table?
Extract from books online with more detailed info..
SQL Server can have as many as 2 billion tables per database and 250 columns
per table. The number of rows and total size of the table are limited only
by the available storage. The maximum size of a database is 1 terabyte (TB).
A table can be as large as 1 TB minus the size of the database catalog and
any other objects. The maximum number of bytes per row is 1962. If you
create tables with varchar or varbinary columns whose total defined width
exceeds 1962 bytes, the table is created but a warning message appears.
Trying to insert more than 1962 bytes into such a row or to update a row so
that its total row size exceeds 1962, produces an error message and the
statement fails. For details on calculating row size, see the Microsoft SQL
Server Administrator's Companion.
Hope the above helps.
Torver Computer Consultants Ltd.