Maximum for objects in sql server
Here are some maximum number of different objects in sql server. maximum number of character in table name-128 maximum number of character in column name-128 maximum number of table columns per select statement -4096 maximum number of table columns per table-1024 maximum number of foreign key reference per table-253 maximum number of column per index-16