Giving a strong name to Default Values

Can you strong-name default values.

I'm looking for the "inline" way, and the "after the fact way".

Inline = NumberOfFloors

After the Fact = NumberOfSides

Here is a working example.



Why? When I need to drop a column at a later date.......I need to drop the
default value first.

I'm trying to get away from the Microsoft random names so I can do the drop
easier.

RandomName Example : DF__Buildin__NumberOf__4FDCC2C0



--start TSQL

if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Building]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

BEGIN

DROP TABLE [dbo].[Building]

END

GO

CREATE TABLE [dbo].[Building] (

BuildingUUID [uniqueidentifier] not null default NEWSEQUENTIALID() ,

BuildingName varchar(64) not null ,


NumberOfFloors int not null DEFAULT 1 /* Can you name the default HERE */ ,

NumberOfSides int not null

)

GO



ALTER TABLE [dbo].[Building] ADD DEFAULT (4) FOR NumberOfSides --<<Can you
name this





GO



Insert Into dbo.Building ( BuildingName ) values ('Sears Tower')

select * from dbo.Building

Yes, and in many shops this is a best practice.


CREATE TABLE #foo
(
id INT,
a INT NOT NULL CONSTRAINT [default_for_a] DEFAULT 10,
b INT NOT NULL
);
GO
ALTER TABLE #foo ADD CONSTRAINT [default_for_b] DEFAULT(20) FOR b;
GO
INSERT #foo(id) SELECT 1;
GO
SELECT id,a,b FROM #foo;
GO
DROP TABLE #foo;
GO


On 4/1/09 12:47 PM, in article #60wAmusJHA.1240@TK2MSFTNGP02.phx.gbl,
"sloan" wrote:

>
>
> Can you strong-name default values.
>
> I'm looking for the "inline" way, and the "after the fact way".
>
> Inline = NumberOfFloors
>
> After the Fact = NumberOfSides
>
> Here is a working example.
>
>
>
> Why? When I need to drop a column at a later date.......I need to drop the
> default value first.
>
> I'm trying to get away from the Microsoft random names so I can do the drop
> easier.
>
> RandomName Example : DF__Buildin__NumberOf__4FDCC2C0
>
>
>
> --start TSQL
>
> if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[Building]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
>
> BEGIN
>
> DROP TABLE [dbo].[Building]
>
> END
>
> GO
>
> CREATE TABLE [dbo].[Building] (
>
> BuildingUUID [uniqueidentifier] not null default NEWSEQUENTIALID() ,
>
> BuildingName varchar(64) not null ,
>
>
> NumberOfFloors int not null DEFAULT 1 /* Can you name the default HERE */ ,
>
> NumberOfSides int not null
>
> )
>
> GO
>
>
>
> ALTER TABLE [dbo].[Building] ADD DEFAULT (4) FOR NumberOfSides --<<Can you
> name this
>
>
>
>
>
> GO
>
>
>
> Insert Into dbo.Building ( BuildingName ) values ('Sears Tower')
>
> select * from dbo.Building
>
>