dbTalk Databases Forums  

Is it possible to "disable" all restrictions on a Ms sql DB?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Is it possible to "disable" all restrictions on a Ms sql DB? in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Flare
 
Posts: n/a

Default Is it possible to "disable" all restrictions on a Ms sql DB? - 08-05-2003 , 05:08 PM






In meen. primary keys, NOT NULL, IDENTETIES...et.c

I have to do a maunally, one time, building of a database. Sometables has to
stay an some are to be exchanged. The foreignkey inforcemnt ill do for my
self so everything is correct. I just need to be allowed to de thede task
for a while. Is it impossible?

Regards
Anders



Reply With Quote
  #2  
Old   
Simon Hayes
 
Posts: n/a

Default Re: Is it possible to "disable" all restrictions on a Ms sql DB? - 08-06-2003 , 04:22 AM






"Flare" <dct_flare (AT) hotmail (DOT) com> wrote

Quote:
In meen. primary keys, NOT NULL, IDENTETIES...et.c

I have to do a maunally, one time, building of a database. Sometables has to
stay an some are to be exchanged. The foreignkey inforcemnt ill do for my
self so everything is correct. I just need to be allowed to de thede task
for a while. Is it impossible?

Regards
Anders
You can disable foreign keys, check constraints and triggers with
ALTER TABLE. But you can't disable primary keys, NULL/NOT NULL is
(usually) part of the column definition, and IDENTITY is a column
property, so they can't be enabled/disabled in the same way.

It's not entirely clear from your comments what problems you're having
with the import, so if you can be more specific then perhaps someone
can help.

Simon


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.