I'm very very new to SQL Server. I used it on a very limited basis a number of years ago to run some queries on a database created by someone else. I learned only a smattering of query related commands. I'm trying to create my own database for a small webpage backend. I've created a local environment for creating and testing but my ultimate goal is to host everything at IONOS. The local environment uses MS SQL Server and SSMS. I've created a few simple tables as a way of learning.
I want to become independent of the SSMS GUI and write scripts to run against my database. At the moment, I'm working with DDL to get my table structures perfected. I need to add a column to a table but ran into problems when I selected a column name, right clicked and chose the Insert option. When I tried to close and save the table, I got an error saying that the Project couldn't be changed in that manner. After some searching and reading a tutorial or 2 later, I learned that I should be using scripting and that the syntax to use is "ALTER TABLE tablename ADD columnname (type);"
Not knowing any better I looked for and found the SSMS Command Window and and guessed that I could enter the command there to change my table. That's when I encountered the rejection of everything I tried to enter as not being valid.
Granted, I have a great deal to learn. FWIW I was a mainframe programmer in the days of punched card decks. I'm learning a whole new toolset and set of languages. It's been a slow crawl.
If anyone can set me straight given the information I've shared, I will be very grateful. The ss shows my results:

Add comment
Please sign in to leave a comment.