SQL Script with default values

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL Script with default values

Author

Topic

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2005-03-17 : 09:01:25

Hey all,

I am generating scripts for my tables so that I can do some stuff

I have a few tables with BIT fields that I have set a default value of 0 to...

Now when I script my tables it does everything perfectly even my identity and seed values, but I cant seem to catch the bit default.

Is there a check box I am missing?

Thanks

Pace

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-17 : 09:48:12

if you do it in EM that you have create table identities and alter table that adds differnt constraint (FK's, defaults...)
if you do it in QA then it's all in the create table (at least default is

)

Go with the flow & have fun! Else fight the flow

Pace
Constraint Violating Yak Guru

264 Posts

Posted - 2005-03-18 : 04:26:49

Thank you!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources