In SQL Server 2000, how many tables can be created in a database and how many fields can be created in each table?

1. Database: 32767 databases. The minimum value is 1 MB and the maximum value is 1 TB.
2. Tables: each database can have a maximum of 2 billion tables.
3. Column: Each table can have a maximum of 1024 columns, and each column has a maximum of 8060 bytes (except for text and image columns ).

Each database of SQL Server can store up to 2 billion tables, and each table can have 1024 columns. The number of rows and total size of a table are limited by the available storage space. Each row can store up to 8,060 bytes. If you create a table with varchar, nvarchar, or varbinary columns, and the total number of bytes of the column exceeds 8,060 bytes, you can still create this table, but a warning message is displayed. If you try to insert a row that exceeds 8,060 bytes or update the row so that the total number of bytes exceeds 8,060, an error message is displayed and the statement execution fails.