Subscribe to this thread
Home - General / All posts - ALTER TABLE [Table 1] RENAME [Table 2]

6,356 post(s)
#12-Aug-19 18:58

Looks like I can not code to rename a table in SQL like I can using the API. That way I could save the use of an addition temporary table for sorting.

This is only part of a SQL-hack around what I really need in Vb.NET. That's a <Table>.SearchAll() using a certain index, not the index of the identifier [mfd_id].

So a way to make <table>.SearchBatch(index, keys,{fields}) accept any record with a dummy key would work even better.


8,776 post(s)
#13-Aug-19 12:32

We have RENAME as a separate statement, on the same level as ALTER: RENAME TABLE [old] [new];

We use ALTER TABLE [...] (RENAME ...) to rename fields, indexes and constraints.

Manifold User Community Use Agreement Copyright (C) 2007-2019 Manifold Software Limited. All rights reserved.