SQL Server/T-SQL/Data Type/char

Specifying Fixed-Width Data Types for Table Columns

 

5> IF EXISTS(SELECT name FROM sys.tables
6>     WHERE name = "T")
7>     DROP TABLE T
8>
9> CREATE TABLE T (
10>     c1 int,
11>     c2 char(49),
12>     c3 char(8000)
13> )
14>