由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Help on MS SQL code
相关主题
another question--怎么delete a row from a tabledisable constraint
a oracle question请教constraints
can't disable a constraintSQL Server Trigger on System Base Table or Catalog View
truncate和delete在ORACLE里有什么区别?MS SQL Server I18N?
SQL 2008 Create Index vs Rebuild Index (Alter Index)[转载] Windows 2003/XP IIS server不兼容?
MS SQL怎么加conditional checkQuestion on create a database in DB2
如何用SQL语句判断一个TABLE是否存在?Oracel, My SQL是不是case sensitive?
关于sql server的script问题mysql index优化求助 (转载)
相关话题的讨论汇总
话题: sql话题: dbo话题: table话题: null话题: collate
进入Database版参与讨论
1 (共1页)
w******w
发帖数: 215
1
What does following code do?
and what is corresponding My SQL code?
Thanks!
************************
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[FK_forum_bbsconfig]') and OBJECTPROPERTY(id,
N'IsForeignKey') = 1)
ALTER TABLE [dbo].[forum] DROP CONSTRAINT FK_forum_bbsconfig
GO
........
........
........
CREATE TABLE [dbo].[calendar] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[title] [varchar] (255) COLLATE Chines
1 (共1页)
进入Database版参与讨论
相关主题
mysql index优化求助 (转载)SQL 2008 Create Index vs Rebuild Index (Alter Index)
数据存储时, charset选错了, 能改正吗?MS SQL怎么加conditional check
MySQL table either insert or drop/truncate table running forever如何用SQL语句判断一个TABLE是否存在?
谁知道下面这段是什么意思(ABOUT CONSTRAINTS)关于sql server的script问题
another question--怎么delete a row from a tabledisable constraint
a oracle question请教constraints
can't disable a constraintSQL Server Trigger on System Base Table or Catalog View
truncate和delete在ORACLE里有什么区别?MS SQL Server I18N?
相关话题的讨论汇总
话题: sql话题: dbo话题: table话题: null话题: collate