Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ALTER TABLE with Default

Status
Not open for further replies.
gavinjb

gavinjb

Programmer
Apr 24, 2003
106
0
0
GB
Hi,

I am trying to write a SQL DDL Statement to add a column to my 'Documents Table' called DateLoaded with the default value of Now(), does anyone know how to do this.

Regards,



Gavin,
 
Sort by date Sort by votes
Sorry, proberly didn't put that very well, my Problem is with writing the statement, I can write the part to create the column,b ut Can't work out how I set the Default Value on this new column in DDL.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
106
Andrzejek
Andrzejek
datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
140
dhookom
dhookom
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
174
lameid
lameid
serino
  • Locked
  • Question
Delete with WHERE Clause. 2
Replies
4
Views
122
serino
serino
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
77
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top