sql如下:
SELECT TABLE_NAME,COLUMN_NAME,TABLE_NAME+'.'+COLUMN_NAME as testColumn
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'APN_USER'
order by table_name asc,column_name asc
;
sql如下:
SELECT TABLE_NAME,COLUMN_NAME,TABLE_NAME+'.'+COLUMN_NAME as testColumn
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'APN_USER'
order by table_name asc,column_name asc
;