I have a file saved using BCP and I want to know the specification of the table of the database that it needs to be materialized on the database. Is that possible?
Thanks
Sql-server – SQL Server BULK INSERT
bcpbulksql server
Related Question
- Sql-server – How to avoid delimiter character in BCP export
- SQL Server – Importing Data in Parallel
- SQL Server – Creating Format Files to Import TXT File
- Sql-server – Sql server bulk insert remove text qualifier
- SQL Server BCP – How to Load a Table Using BCP
- Sql-server – OPENROWSET Bulk insert Text File NULL Columns
Best Answer
You can do this using the BCP format parameter. This will create a format file of the table for you.
Based on your requirement, you can create XML/native/character formatted files.
eg:
bcp db_name.schema_name.table_name format nul -T -n -f format-file.fmt