Hi,

The max number of columns a SQL table can have is

1024.

Cheers

vijay

--- Arundhati Bopardikar <Bopardikar@Q...>

wrote:

> Hi,

>  

> Is there a limit on the number of columns a SQL

> table has?

> I would really appreciate any help

>  

> Regards,

> Arundhati

> 

> 





> $subst('Email.Unsub').

> 





__________________________________________________

Do You Yahoo!?

Try FREE Yahoo! Mail - the world's greatest free email!

http://mail.yahoo.com/

This is a multi-part message in MIME format.



------=_NextPart_000_0138_01C1C540.DBC84AC0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



I hope this helps.  For SQL Server:



Databases and Files

SQL Server 7.0 simplifies the relationship between a SQL Server database 

and the Microsoft Windows=AE file system, enabling greater scalability.



In SQL Server 7.0, databases reside on operating-system files instead of 

on SQL Server logical devices. You can create a database and all its 

files with a single CREATE DATABASE statement. SQL Server Enterprise 

Manager can create new databases and modify (alter) existing databases.



Database devices and segments no longer reside on top of the 

operating-system files; rather, a SQL Server 7.0 database consists of 

two or more Windows files. Each Windows file is used by only one 

database. A single file cannot be shared by multiple databases. When a 

database is dropped, its files are also deleted.



SQL Server 7.0 allows database files to expand automatically, 

eliminating the need for administrators to issue an additional ALTER 

statement. SQL Server 7.0 includes new CREATE DATABASE syntax that 

incorporates this file-based implementation.



Filegroups are supported. Filegroups are similar to the user-defined 

segments available in earlier versions of SQL Server.



SQL Server 7.0 supports movable databases, the ability to move a 

database by moving, copying, or e-mailing the database files from one 

server to another and attaching them to the copy of SQL Server running 

on the target server.



Pages, Rows, and Columns

All database pages are now 8 KB in size, increased from 2 KB. The 

maximum number of bytes in a row is now 8060 bytes, and the limit on 

character and binary data types is 8000 bytes, increased from 255 bytes. 

Tables can now have 1024 columns, a significant increase over the 250 

columns supported earlier. The new page and row formats support 

row-level locking, are extensible for future requirements, and improve 

performance when large blocks of data are accessed, because each I/O 

operation retrieves more data.











  ----- Original Message -----

  From: Arundhati Bopardikar

  To: ASP Databases

  Sent: Wednesday, March 06, 2002 8:24 PM

  Subject: [asp_databases] limit on SQl table columns





  Hi,



  Is there a limit on the number of columns a SQL table has?

  I would really appreciate any help



  Regards,

  Arundhati




$subst('Email.Unsub').

This is a multi-part message in MIME format.



------=_NextPart_000_0025_01C1C533.C4D657B0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



Hi,



Is there a limit on the number of columns a SQL table has?

I would really appreciate any help



Regards,

Arundhati