Root

The root reference table that is always present in the FTP schema. It serves as the anchor point for connection discovery, allowing other FTP-related tables to be detected automatically through the TableDepth property.

テーブル固有の情報

Select

ディレクトリ内のすべてのファイルとディレクトリを取得します。

SELECT * FROM Root

Insert

サーバーにファイルをアップロードするには、LocalFile およびFilename を指定する必要があります。

INSERT INTO Root (Localfile, Filename) VALUES ('D:\\\\ShareFolder\\\\Notes.txt', 'NewNotes.txt')

サーバー上に新しいディレクトリを作成するには、Filename を指定してIsDirectory をTrue に設定する必要があります。

INSERT INTO Root (Filename, IsDirectory) VALUES ('New Directory', true)

Update

ファイルの名前のみ更新できます。WHERE 句でFilePath を指定する必要があります。

UPDATE Root SET Filename = 'OldNotes.txt' WHERE FilePath = '/Documents/Test/NewNotes.txt'

Delete

FilePath を指定して、ファイルを削除します。

DELETE FROM Root WHERE FilePath = '/Documents/Test/OldNotes.txt'

FilePath を指定し、IsDirectory をTrue に設定してディレクトリを削除します。

DELETE FROM Root WHERE FilePath = '/Documents/Test' AND IsDirectory = true

Columns


Name	Type	ReadOnly	Description
FilePath [KEY]	String	True	Full path of the file or directory on the FTP/SFTP server, showing its exact location within the server's folder structure.
Filename	String	False	The name of the file or directory, excluding the full path, identifying the item within its parent folder.
FileSize	Long	True	Displays the size of the file in bytes, with directories always showing a size of 0.
LastModified	Datetime	True	A timestamp indicating the last time the file or directory was modified on the server.
IsDirectory	Boolean	True	Indicates whether the entry represents a directory (true) or a file (false).
LocalFile	String	True	The local system file path for uploading to the server. Applies only when inserting new files.
Permissions	String	True	The permission settings for a file or directory, typically shown in a format that uses r for read, w for write, and x for execute.
Owner	String	True	The username of the account that owns the file or directory on the server.
Group	String	True	The group name assigned to the file or directory, which can define shared access rights.