Answer: You can give table name upto 116 characters only including # sign.
Create table #<more than 116 characters table name>
(
ID int,
NAME varchar(50)
)
You will get the following error.
Error: "The object or column name starting with '#<long string here>' is too long. The maximum length is 116 characters."
Asked In: Many Interviews |
Alert Moderator