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 : Create Table « Table « SQL Server / T-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
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>