Adding to my confusion (see previous post),  I selected clan.parents table then right clicked and chose Relationships.  I don't understand what the window in the ss tells me.  I never...

• This reply was modified 7 months ago by Ahr Aitch.

Thank you!

I failed to discover that piece of information despite searching with differently worded arguments.

One would think that would be the default view for tables in diagram view . ....

My dad was a Mergenthaler Lin-O-Type operator.  He set type for decades.  I learned about etaoin shrdlu from him probably more than 70 years ago.

He had a favorite trick when...

Before reading further, please understand that I am a rank noob . . .  and I do mean RANK.  I’ve done a couple of online tutorials and starting practicing, but...

Thank you, Gentlemen.

That's good information.  I smacked my forehead over the images suggestions.  I had planned on having links and pathnames in tables and just sort of assumed I need...

Realizing that I have no clue, I wondered if there are any best practices for choosing data types for such commonly used variables as firstNames, middleNames, lastNames, suffixes, cityNames, countyNames,...

• This reply was modified 7 months ago by Ahr Aitch. Reason: correct typos, add emphasis

Thanks, Jeff.

I learned a good deal from your post.  I did not know about the square brackets syntax requirement. I also learned more about using schema.

Thanks, again.

After dropping PK as an attribute, I was able to delete the column.  I did so and added a column with that name, set the type to smallint, and gave...

dbo.clan.spouses is a 3 part name where dbo is the database, clan is the schema and spouses is the table.

Looking at your screen shot you probably want dbo.[clan.spouses], where...

• This reply was modified 7 months ago by Ahr Aitch.

. . .  and yet another question

What, if any, significance do the square brackets around elements in the example have in this ss?  Are they literal or placeholder markers?

• This reply was modified 7 months ago by Ahr Aitch.

Continuing this thread . . .

It's my understanding that the sp_refreshqlmodule command will update metadata, metadata that must be updated for SSMS to display all the column names in a...

• This reply was modified 7 months ago by Ahr Aitch.

Thank you, Jeff.

If I weren't so ignorant about SQL generally - and SSMS particularly - the searching I did might well have told me something useful.  In fact the results...

• This reply was modified 7 months ago by Ahr Aitch.
• This reply was modified 7 months ago by Ahr Aitch.

Thanks, Ken.

I haven't tried that yet but think I understand it.

Big thanks to you and Jeffrey . . .

I've been able to alter table structures (adding columns), alter data types...

• This reply was modified 7 months ago by Ahr Aitch.

You need to put SQL in a Query Window. This can be opened on the top left of SSMS.

dbo is the default schema. You can create your own schemas...

Thank you, Ken!

I had a feeling I had the wrong interface.