What is the maximum number of columns a database table can have ? Is there a limit on that ? Thanks in advance.
Jan 13, 2010 at 11:49 AM
The maximum is 1000 columns per table or view.
Jan 13, 2010 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.
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, 2010 at 11:49 AM
Seen: 2793 times
Last Updated: Jan 13, 2010 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 ?
What is a Parent table in Oracle ?
Oracle Full backup and restore any time (snapshot) ?
What are the various types of database triggers ?
How to Migrate of 10TB database from 9i to 10g + 10 standby sites ?
Can flashback of database be implemented more than once after resetlogs?
Manage max table storage space in case of excess data (size in GB)
How to import tables to different tablespace ?