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

1. SQL Server / T-SQL
2. Table
3. Create Table

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>
           
       

Related examples in the same category