MySQL Forums
Forum List  »  Newbie

Add default value all records new column
Posted by: Pedro Camara
Date: July 03, 2022 06:01AM

Hi guys
I have a query with a SELECT statement, joins 2 other queries, filter a column and order another one.
I would love to add a new column with a static value for all records, past and future.
I believe i should add these lines:

Alter Table dbo.CabecDoc
ADD Company VARCHAR (50) Not NULL
Constrain DF_Company default 'S&A'

But i don't know where, in the statement query....at the beginning, at the end, in the middle....

Can anyone help me please?
Thanks a lot all of you

P.S. If this isn't the right place to ask please let me know where

Options: ReplyQuote


Subject
Written By
Posted
Add default value all records new column
July 03, 2022 06:01AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.