SQL Server

UPDATE:2023-06-13

On this page

ODBC

  1. Driver
  2. DSN Setting
    Windows : ODBC data source administrator

Method

  1. [System]Get TableName(Use sequential numbers instead.)
    SET tables.object_id,tables.name,schemas.nam FROM sys.tables
  2. [System]Get FieldName and FieldType
    SELECT C.column_id,c.name,TABLE_SCHEMA FROM sys.columns C WHERE C.object_id="<tables.object_id>"