如何用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 語句用于創建數據庫中的表。
具體用法為: 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語句創建表,要完整的語句
自己打開企業管理器,隨便找個表,導出一個創建表的腳本,就什么都有了。
要語法,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} }。
sql語句創建表
學生表
create table tblStudent(
Sid int indentity(1,1) primary key,
Sname nvrchar[20] not null,Sage int not null check(Sage>=16 and SageSsex nchar[1] default '男')
課程表(tblCourse),
create table tblCourse(
Cid int indentity(1,1) primary key,
Cname nvarchar[20] not null unique;TId int not null) 成績表(tblScore):
create table tblScore(
Sid int not null,
Cid int not null,
Score int not null,
primary key(Sid,Cid),
foreign key Sid references tblStudent(Sid),
foreign key Cid references tblCourse(Cid)
) 教師表(tblTeacher):
create table tblScore(
TId int indentity(1,1) primary key,
Tname nvarchar[20] not null)
用sql 建立表
CREATE TABLE A(A# varchar(10) PRIMARY KEY,ANAME varchar(8) NOT NULL, QTY varchar(14), CITY varchar(20)) insert into A values('A2','劉明','100','上海'),('A3','楊敏','300','濟南'),('A1','馬剛','200','北京'),('A4','李明','400','深圳'),('A6','李雪','300','天津')CREATE TABLE B(B# varchar(10) PRIMARY KEY,BNAME varchar(8) NOT NULL, COLOR varchar(14), CITY varchar(20)) insert into B values('B1','短袖','綠色','濟南'),('B5','連衣裙','藍色','上海'),('B2','褲子','紅色','北京'),('B4','夾克衫','褐色','天津'),('B2','兩件套','黃色','石家莊'),('B3','天鵝絨','綠色','廣州')這是A、B兩個表的創建和插入數據,但是我看你這個C表應該是跟A、B表是有關系的吧,但是你這個對應過程好像不太對啊,具體的對應順序既不是按排序對應的,也不是按數據表中的位置對應的,所以我也不太明白,你這個C表示什么意思?而且C#還有重復的,原則上來說C#應該是主鍵,主鍵都是唯一的啊!。
SQL語句創建的表在哪
所謂臨時表,即我們臨時創建來用一下的表,也就是說這個表只是臨時創建來用一會兒的,再我們使用完之后就會進行刪除的表。
我們在對數據庫操作的時候,會常常用到一些臨時的數據,這時候使用臨時表來存放這些東西最合適不過了。我們可以使用create語句來創建一個臨時表,具體語法如:create global trmprary table temp_emp(DSN Number,DNAME VARCHAR(20)) On Commit Rows;其中On Commit Rows表示關機之后就刪除這個臨時表,或許你會覺得這樣不好,當然我們還有其他的方式,比如:如果你想在關閉表的時候就刪除的話,我們可以寫上這條語句:On Commit PRESERVE Rows。