What is the maximum number of columns a database table can have ? Is there a limit on that ? Thanks in advance.
Jan 13 '10 at 11:49 AM
The maximum is 1000 columns per table or view.
Jan 13 '10 at 12:36 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jan 13 '10 at 11:49 AM
Seen: 1877 times
Last Updated: Jan 13 '10 at 11:49 AM
If the large table contains thousands of records and the application is accessing 35% of the table which method to use ?
Relationship among database, tablespace and data file ?
How to add one more field to the below existing table ?
How to disable database trigger ?
Differences among Synonym, Alias and View of a database table ?
backup database primavera
Action initiation after inserting a record in a table?
How do we resize a data file?
How can we mount a Database with the Parallel Server for more instances?
Can we skip certain columns while loading data ?