The CHECK command, including database or table names, cannot exceed 1300 characters. Wildcard characters are counted as single characters. For more information, see Valid Characters in Object Names and Wildcard Characters in Names.
The CHECK command is not case sensitive. You can specify the syntax elements in uppercase or lowercase or a mixture of both. This also applies to names specified in wildcard syntax.
CheckTable can check an unlimited number of databases and tables, however the CHECK command accepts a maximum of 30 names on the command line. Names of the form dbname, tablename, and dbname.tablename are each considered to be a single name. However, wildcard expressions are also considered to be single names, and can resolve to any number of databases and tables. For more information on using wildcard expressions, see Wildcard Characters in Names.