How to: Create Tables (Visual Database Tools)

Using Table Designer, you can create a new table, name it, and add it to an existing database.

Note

If you are connected to a SQL Azure database, the new table option launches a create table template script. Edit the parameters, then run the script to create a new table. For more information, see SQL Azure Overview.

To create a new table with Table Designer

  1. Right-click the Tables node of your database in Object Explorer and click New Table.

  2. Type column names, choose data types, and choose whether to allow nulls for each column.

  3. From the File menu, choose Save table name.

  4. In the Choose Name dialog box, type a name for the table and click OK.