Limitations of Sql server Tables


  • The maximum number of columns per base table is 1024.

  • The maximum number of columns per index is 16.

  • The maximum number of columns per SELECT statement is 4096.

  • The maximum number of foreign key table references per table is 253.

  • The maximum number of parameters per stored procedure is 1024.

  • The maximum number of characters allowed for a table name is 128.

  • The maximum number of characters allowed for a column name 128.

  • The maximum number of columns in the view is 250.

Category : | Read More......