華閱文章網SQL語句創建表
CREATE TABLE 語句用于創建數據庫中的表。
具體用法為： CREATE TABLE 表名稱 （ 列名稱1 數據類型， 列名稱2 數據類型， 列名稱3 數據類型， 。. ） 擴展資料： 創建表數據類型： integer(size) int(size) smallint(size) tinyint(size)：僅容納整數。
decimal(size,d) numeric(size,d)：容納帶有小數的數字。 char(size)：容納固定長度的字符串 varchar(size)：容納可變長度的字符串 date(yyyymmdd)：容納日期。
參考資料：百度百科-SQL CREATE TABLE。
如何用sqL語句創建表,要完整的語句
如果id不是標識自動加1，則語句如下：
if exists (select * from *ects where id = object_id(N'[dbo].[ufdd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ufdd]
GO
CREATE TABLE [dbo].[ufdd] (
[id] [int] NOT NULL ,
[citem] [varchar] (22) NULL ,
[citemc] [tinyint] NULL ,
[bitem] [bit] NOT NULL
) ON [PRIMARY]
GO
如果id是標識自動加1，則語句如下：
if exists (select * from *ects where id = object_id(N'[dbo].[ufdd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ufdd]
GO
CREATE TABLE [dbo].[ufdd] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[citem] [varchar] (22) NULL ,
[citemc] [tinyint] NULL ,
[bitem] [bit] NOT NULL
) ON [PRIMARY]
GO
用SQL語句創表
create table S
(MNO varchar(10),
PNO varchar(10),
QTY number(10) not null,
primary key(MNO));
和上一位區別在于定義字符時用了varchar,
數據庫一般提供char,varchar,varchar2幾種存儲字符的數據結構。如定義char(10)，那么當你存放的數據占了5個字節的時候，存儲器上開辟的另5個字節容量就是為空，但是仍占著地方；而varchar(10)就可以根據實際數據大小來選擇，但是當數據庫查找或更新數據時，瀏覽char的數據較快，一般也沒有太大區別，除了有很多數據；varchar2和varchar的區別，前者是用unicode編碼，后者是ASCII碼，所以前者一個占兩個字節，后者是一個。
如何使用SQL語句創建表,要完整的語句
自己打開企業管理器，隨便找個表，導出一個創建表的腳本，就什么都有了。
要語法，SQL的聯機幫助里就有：CREATE TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name ( { | } [ ] [ ,。n ] ) [ ON { partition_scheme_name ( partition_column_name ) | filegroup | "default" } ] [ { TEXTIMAGE_ON { filegroup | "default" } ] [ ; ] ::=column_name [ COLLATE collation_name ] [ NULL | NOT NULL ] [ [ CONSTRAINT constraint_name ] DEFAULT constant_expression ] | [ IDENTITY [ ( seed ,increment ) ] [ NOT FOR REPLICATION ] ] [ ROWGUIDCOL ] [ [ 。
n ] ] ::= [ type_schema_name . ] type_name [ ( precision [ , scale ] | max | [ { CONTENT | DOCUMENT } ] xml_schema_collection ) ] ::= [ CONSTRAINT constraint_name ] { { PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED ] [ WITH FILLFACTOR = fillfactor | WITH ( [ , 。n ] ) ] [ ON { partition_scheme_name ( partition_column_name ) | filegroup | "default" } ] | [ FOREIGN KEY ] REFERENCES [ schema_name . ] referenced_table_name [ ( ref_column ) ] [ ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] [ NOT FOR REPLICATION ] | CHECK [ NOT FOR REPLICATION ] ( logical_expression ) } ::=column_name AS computed_column_expression [ PERSISTED [ NOT NULL ] ][ [ CONSTRAINT constraint_name ] { PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED ] [ WITH FILLFACTOR = fillfactor | WITH ( [ , 。
n ] ) ] | [ FOREIGN KEY ] REFERENCES referenced_table_name [ ( ref_column ) ] [ ON DELETE { NO ACTION | CASCADE } ] [ ON UPDATE { NO ACTION } ] [ NOT FOR REPLICATION ] | CHECK [ NOT FOR REPLICATION ] ( logical_expression ) [ ON { partition_scheme_name ( partition_column_name ) | filegroup | "default" } ]] ::=[ CONSTRAINT constraint_name ] { { PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED ] (column [ ASC | DESC ] [ ,。n ] ) [ WITH FILLFACTOR = fillfactor |WITH ( [ , 。
n ] ) ] [ ON { partition_scheme_name (partition_column_name) | filegroup | "default" } ] | FOREIGN KEY ( column [ ,。n ] ) REFERENCES referenced_table_name [ ( ref_column [ ,。
n ] ) ] [ ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] [ NOT FOR REPLICATION ] | CHECK [ NOT FOR REPLICATION ] ( logical_expression ) } ::={ PAD_INDEX = { ON | OFF } | FILLFACTOR = fillfactor | IGNORE_DUP_KEY = { ON | OFF } | STATISTICS_NORECOMPUTE = { ON | OFF } | ALLOW_ROW_LOCKS = { ON | OFF} | ALLOW_PAGE_LOCKS ={ ON | OFF} }。
