search

philanderson888 / c-sharp

A repository for teaching C#
MIT License
2 stars 1 forks source link

Personal Project FamilyDatabase04 - extend the comments database field #18

Closed philanderson888 closed 4 years ago

philanderson888 commented 4 years ago

The field at the moment is a little bit short and hinders my comments, so I wish to extend it to be a little bit longer. Check out my previous database for an example of a suitable length.

philanderson888 commented 4 years ago

Yes fixed it no problem with this script

Azure

FamilyDatabase04 (phildatabaseserver/FamilyDatabase04) - Query editor (preview)

select * from information_schema.columns where table_name = 'DailyLogs'

ALTER TABLE [dbo].[DailyLogs] ALTER COLUMN Comments NVarChar(255) Null;

select * from information_schema.columns where table_name = 'DailyLogs'