MS Access - default value in create table
| From: | Nuttzy | Date: | Mon, 15 Jul 2002 18:29:18 +0000 |
| Subject: | MS Access - default value in create table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20558@lists.php.net to get a copy of this message | ||
I can create tables and perform alterations just fine. However, if I try to
specify a DEFAULT value in either CREATE TABLE or ALTER TABLE, it craps out
on me. For example, this works....
ALTER TABLE phpbb_mytable
ALTER COLUMN LastName TEXT(40)
...but this doesn't....
ALTER TABLE phpbb_mytable
ALTER COLUMN LastName TEXT(40) DEFAULT Unknown
...even though I believe this is the correct syntax. Same thing happens for
CREATE TABLE. Help!!!
Thanks,
-Nuttzy