开发者

When importing data into a table in SQL, what is the duplicate table name with the Suffix "$"

开发者 https://www.devze.com 2023-02-08 08:42 出处：网络

So I exported two tables in their entirety out of S开发者_开发技巧QL (2005) into an excel file.During the import wizard to import the tables, on the screen presenting the tables to import it showed 4

相关专题：import sql

So I exported two tables in their entirety out of S开发者_开发技巧QL (2005) into an excel file. During the import wizard to import the tables, on the screen presenting the tables to import it showed 4 tables.

Two which were duplicate names with the small difference of having the suffix "$" on the end. I chose to import all 4 and it went through.

Are the tables with the "$" suffix metadata or some other information?

The $ is what you see when you are working with Worksheets in Excel. If you want to import into the same table, get rid of the automagic naming and import into the table itself.

Want proof? Export tables to an Excel spreadsheet. Reimport without removing the $. Compare data between the tables. You will not have all of your constraints on the "$" tables and the data types might be off, but the data will be identical.