Table Folder Column Folder

[zezo2021]

Can I delete a column from the column folder or rename it from the column folder
Is this like delete or rename in the table design in SQL SERVER

 

[isladogs]

Not sure what you mean by 'column folder'

You can delete a column (field) in design view
You can also do this in datasheet view if Enable design changes for tables in Datasheet view is ticked in Access Options | Current Database

 

[theDBguy]

Perhaps post some screenshots to clarify your question?

 

[zezo2021]

Perhaps post some screenshots to clarify your question?

Sorry, node not folder

 

[theDBguy]

Is that a screenshot from SSMS? Or Access?

 

[theDBguy]

Have you tried right-clicking on the column name?

 

[isladogs]

Just realised this is in the SQL Server forum

 

[MadPiet]

Are you talking about doing that in Access? Seems like you must be, because you can right-click and delete columns from tables in SQL Server if you wish. I don't think so. You'd have to open the table in design view and delete the columns.

 

[zezo2021]

Have you tried right-clicking on the column name?

View attachment 121078

thanks

 

[isladogs]

You can't directly delete columns for linked tables from Access (other than by using DDL queries)
However, you can hide any linked table columns that you don't want to use in Access