SQL Server/T-SQL/Table/Create Table

Материал из SQL эксперт
Перейти к: навигация, поиск

CREATE TABLE statement contains the table name, its column definitions in parentheses. For each column, a name, data type specification, and NULL specification are provided

   <source lang="sql">

1> -- CREATE TABLE 2> 3> -- CREATE TABLE statement contains the table name, its column definitions in parentheses. For each column, a name, data type specification, and NULL specification are provided 4> 5> CREATE TABLE MyTable (MyID Int NOT NULL, MyDescription nVarChar(50) NULL) 6> GO 1> 2> drop table MyTable 3> GO 1>

      </source>