SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    _ silver trophy ses5909's Avatar
    Join Date
    Jul 2003
    Location
    NoVa
    Posts
    5,466
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Question sql server column limit??

    Does Sql Server have a limit on the number of columns a table (record) can have??

    TIA
    Sara

  2. #2
    SitePoint Addict StephenBauer's Avatar
    Join Date
    Apr 2004
    Location
    USA
    Posts
    263
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Check out "limitations-SQL Server objects" in SQL Books Online (BOL):

    "1024 columns per base table (SQL7 and SQL2K)"

    I hope no one ever reached that point!
    Last edited by StephenBauer; May 26, 2004 at 11:24.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •