Check if Constraint is enabled or disabled
This is a script to find all constraints and check if they are enabled or disabled.
2011-11-03 (first published: 2011-10-12)
7,932 reads
This is a script to find all constraints and check if they are enabled or disabled.
2011-11-03 (first published: 2011-10-12)
7,932 reads
This article shows an interesting issue with foreign keys and how they are aligned with the base tables in SQL 2005 SP 4.
2011-10-10
5,862 reads
Foreign key constraints are an integral part of SQL Server database design. These are used to maintain integrity among related data in different tables. While implementing update and delete operations on values in the parent table (referenced table with primary key) we have to consider the impact on related values in the child table. SQL Server provides different rules for managing the effect of updates and deletes on child table values. How can these rules be used effectively without threatening the relational integrity?
2011-05-03
4,940 reads
Gets all columns infos, foreign keys (multicolumn fk handled), referenced primary keys, default and check constraints, indexes, Create/Drop scripts for all constraints.
2011-02-28 (first published: 2011-02-18)
1,627 reads
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2010-02-24 (first published: 2010-02-09)
1,213 reads
2010-01-25
3,961 reads
2010-01-07 (first published: 2009-12-18)
1,760 reads
2009-01-23 (first published: 2009-01-14)
2,046 reads
Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.
2009-01-19 (first published: 2009-01-05)
1,330 reads
2008-10-24
769 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers