if exists (select * from sysobjects where id = object_id(N'[dbo].[pop_tab]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[pop_tab]
GOCREATE TABLE [dbo].[pop_tab] (
[Currency_id] [char] (2) NOT NULL ,
[Subject_id] [char] (2) NOT NULL
) ON [PRIMARY]
GO这是mssql的语句,每种数据库都有些小区别。所以最好用标准sql语句。
例如:
CREATE TABLE pop_tab (
(Currency_id) char (2) NOT NULL ,
(Subject_id) char (2) NOT NULL
)
drop table [dbo].[pop_tab]
GOCREATE TABLE [dbo].[pop_tab] (
[Currency_id] [char] (2) NOT NULL ,
[Subject_id] [char] (2) NOT NULL
) ON [PRIMARY]
GO这是mssql的语句,每种数据库都有些小区别。所以最好用标准sql语句。
例如:
CREATE TABLE pop_tab (
(Currency_id) char (2) NOT NULL ,
(Subject_id) char (2) NOT NULL
)
drop table [dbo].[pop_tab]
GOCREATE TABLE [dbo].[pop_tab] (
[Currency_id] [char] (2) NOT NULL ,
[Subject_id] [char] (2) NOT NULL
) ON [PRIMARY]
GO
这是mssql的语句,每种数据库都有些小区别(判断表是否存在,根据数据库不同而不同)。所以最好用标准sql语句。
例如:
CREATE TABLE pop_tab (
(Currency_id) char (2) NOT NULL ,
(Subject_id) char (2) NOT NULL
)
各种数据库都差不多
if exists(select name from sysobjects where name="JobInfo")
drop table JobInfo
go
create table JobInfo
(
EmJobID Int not null,
EmJobName Varchar(50) not null,
primary key(JobID)
)
go
grant all on JobInfo to public
go