Home » RDBMS Server » Server Administration » Re: How to assign a default value to datatype number for the whole instance
Re: How to assign a default value to datatype number for the whole instance [message #369466] Thu, 28 September 2000 06:20
Gawie Opperman
Messages: 9
Registered: August 2000
Junior Member
Yes it's possible:
1: Create table ...... ( columnname type default 0 )
2: alter table ..... modify ( columnname default 0 )
Ofcourse you can set the default to any value - number/char etc.

Gawie

Report message to a moderator

Previous Topic: spooling limitations
Next Topic: last update
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 14:29:49 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.