By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,581 Members | 2,007 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,581 IT Pros & Developers. It's quick & easy.

maximum number of fields that can be created in a table

P: 5
hi...
I would like to know about maximum number number of fields that can be created in a table. my requirement is to meet data entry in morethan 300 fields. I am using SQL 2000. if impossible is there any other method to incorporate additional fields?
Please reply as soon as possible.
lin
Jun 14 '07 #1
Share this Question
Share on Google+
3 Replies


Purple
Expert 100+
P: 404
Hi linsha,

from memory its 1024 for SQL2k.

I would suggest you take a look again at the data structure and see if you can do some normalisation - take a look at this article for some background reading if required.

Regards Purple
Jun 14 '07 #2

nomad
Expert 100+
P: 664
hi...
I would like to know about maximum number number of fields that can be created in a table. my requirement is to meet data entry in morethan 300 fields. I am using SQL 2000. if impossible is there any other method to incorporate additional fields?
Please reply as soon as possible.
lin
if you have that many fields you might think about many to many relationships. Read up onnormalizations

nomad
Jun 14 '07 #3

P: 5
thankyou for your reply . Let me try it .
lin
Jun 15 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.