如何在数据库中新建一张表？

[yunshiyu]

如何用SQL语言在数据库中新建一张表，并给表起名，设置表内列名，内容？

[zjcxc]

create table 表名(列名 数据类型,列名 数据类型)
例如:
create table tb(a int,b varchar(20)

很表内写入数据
insert into tb(a,b) values(1,"aaa")

[hjb111]

create tableA (id int,name nvarchar(255))
创建一个表了!

[hjb111]

在表中写内容是:

insert tableA values(1234,'记着给俺分!')

[realxuj]

我把连接帮助里的定义给贴出来。。。。

CREATE TABLE
[ database_name.[ owner ] .| owner.] table_name
( { < column_definition >
| column_name AS computed_column_expression
| < table_constraint > ::= [ CONSTRAINT constraint_name ] }

| [ { PRIMARY KEY | UNIQUE } [ ,...n ]
)

[ ON { filegroup | DEFAULT } ]
[ TEXTIMAGE_ON { filegroup | DEFAULT } ]

< column_definition > ::= { column_name data_type }
[ COLLATE < collation_name > ]
[ [ DEFAULT constant_expression ]
| [ IDENTITY [ ( seed , increment ) [ NOT FOR REPLICATION ] ] ]
]
[ ROWGUIDCOL]
[ < column_constraint > ] [ ...n ]

< column_constraint > ::= [ CONSTRAINT constraint_name ]
{ [ NULL | NOT NULL ]
| [ { PRIMARY KEY | UNIQUE }
[ CLUSTERED | NONCLUSTERED ]
[ WITH FILLFACTOR = fillfactor ]
[ON {filegroup | DEFAULT} ] ]
]
| [ [ FOREIGN KEY ]
REFERENCES ref_table [ ( ref_column ) ]
[ ON DELETE { CASCADE | NO ACTION } ]
[ ON UPDATE { CASCADE | NO ACTION } ]
[ NOT FOR REPLICATION ]
]
| CHECK [ NOT FOR REPLICATION ]
( logical_expression )
}

< table_constraint > ::= [ CONSTRAINT constraint_name ]
{ [ { PRIMARY KEY | UNIQUE }
[ CLUSTERED | NONCLUSTERED ]
{ ( column [ ASC | DESC ] [ ,...n ] ) }
[ WITH FILLFACTOR = fillfactor ]
[ ON { filegroup | DEFAULT } ]
]
| FOREIGN KEY
[ ( column [ ,...n ] ) ]
REFERENCES ref_table [ ( ref_column [ ,...n ] ) ]
[ ON DELETE { CASCADE | NO ACTION } ]
[ ON UPDATE { CASCADE | NO ACTION } ]
[ NOT FOR REPLICATION ]
| CHECK [ NOT FOR REPLICATION ]
( search_conditions )
}

[leimin]

楼主你有看帮助么？
气愤！！！！

你是来找保姆么？如果你连基本的帮助都不看，我劝你还是早点改行，免得耽误青春...

[dafu71]

在企业管理器中任选中数据库的一表项然后点右键-->导出sql，试试

[jeck_zhou]

还是自己多看看资料号呀。

[jinxinmin]

还是自己多看看资料

[boynicky]

ft，先可以用右键建好一张新表，然后用右键所有任务——导出sql，看看哪个sql语句自己就知道怎么写了吧！

[形印声传]

晕死，这么弱智的问题也来问？？
稍微动个手，答案也随处可得！~
根本不具备一个it人士的自我钻研精神~~~~改行吧你！

[abcccccc]

在企业管理器中选中数据库的表项然后点右键！试一下吧