如何删除SQl中的约束 [英] how do remove the constraint in SQl

问题描述

嗨团队，



我的表格如下：

Hi Team,

I have the table as follows:

CREATE TABLE [dbo].[K2FILELOG](
    [ID] [bigint] IDENTITY(1,1) NOT NULL,
    [FILEPATH] [varchar](max) NULL,
    [FILENAME] [varchar](150) NULL,
    [FILETYPE] [int] NOT NULL CONSTRAINT [DF__K2FILELOG__FILET__57E7F8DC]  DEFAULT ((0)),
    [FILEDATE] [datetime] NULL,
    [CIRCLEID] [int] NULL,
    [TOTALROWS] [int] NULL,
    [SUCCESSCOUNT] [int] NULL,
    [FAILURECOUNT] [int] NULL,
    [ERROR] [varchar](max) NULL,
    [PROCESSED] [bit] NULL,
    [VENDORID] [int] NULL,
    [CREATEDON] [datetime] NULL,
    [CREATEDBY] [int] NULL,
    [UPDATEDON] [datetime] NULL,
    [UPDATEDBY] [int] NULL,
    [DELETED] [bit] NULL,)

i想要删除[FILETYPE]的约束。怎么可能？

我试过这个但是没有用

i want to remove the constraint for [FILETYPE].How it possible ??
I have try this but no use

alter table [K2FILELOG]
drop constraint [FILETYPE]

它给了我错误：

it gives me error :

Msg 3728, Level 16, State 1, Line 1
'FILETYPE' is not a constraint.

我想删除来自[Filetype]的

I want to remove

CONSTRAINT [DF__K2FILELOG__FILET__57E7F8DC]  DEFAULT ((0)),

。



谢谢

Harshal

from [Filetype].

Thanks
Harshal

推荐答案

简单地说：

Simply:

ALTER TABLE [dbo].[K2FILELOG]
DROP CONSTRAINT [DF__K2FILELOG__FILET__57E7F8DC]

这篇关于如何删除SQl中的约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！