Create the system skeleton generator. about formdin HOT 5 CLOSED

Para MS SQL Server

use ;

select *
from INFORMATION_SCHEMA.TABLES i
where i.TABLE_CATALOG =
AND I.TABLE_SCHEMA =

select c.table_name as "NomeTabela"
,c.COLUMN_NAME as "Coluna"
,c.Is_NULLABLE
,c.DATA_TYPE as "Tipo"
,c.CHARACTER_MAXIMUM_LENGTH as "TamanhoMaximo"
,c.NUMERIC_PRECISION as "PrecisaoNumerica"
--select *
from INFORMATION_SCHEMA.COLUMNS c
where c.TABLE_SCHEMA = 'DBO'
order by c.table_name, c.ORDINAL_POSITION

-- colunas e atributos
select c.table_name as "NomeTabela"
,c.column_name as "NomeColuna"
,c.IS_NULLABLE
--,c.ORDINAL_POSITION
,c.COLUMN_DEFAULT
,c.DATA_TYPE as "Tipo"
,c.CHARACTER_MAXIMUM_LENGTH as "TamanhoMaximo"
,c.NUMERIC_PRECISION as "PrecisaoNumerica"
,prop.value AS [DescricaoColuna]
-- select *
from INFORMATION_SCHEMA.COLUMNS c
join sys.columns AS sc on sc.object_id = object_id(c.TABLE_SCHEMA + '.' + c.TABLE_NAME) AND sc.NAME = c.COLUMN_NAME
LEFT JOIN sys.extended_properties prop ON prop.major_id = sc.object_id AND prop.minor_id = sc.column_id AND prop.NAME = 'MS_Description'
where c.TABLE_SCHEMA = 'DBO'
order by c.table_name, c.ORDINAL_POSITION

from formdin.

SELECT table_name, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'diario_eletronico'
-- AND table_name = 'autoridade'
ORDER BY table_name, ORDINAL_POSITION ;

https://dev.mysql.com/doc/refman/5.7/en/columns-table.html

Choosing a PHP Code Generator – 6 Popular Solutions
https://www.keycdn.com/blog/php-code-generator/

from formdin.

Já existe algo que retorna os campos de uma tabela.
TDAO.loadFieldsFromDatabase

from formdin.

Movido para outro projeto
https://github.com/bjverde/sysgen

from formdin.

Virou um projeto separado !
https://github.com/bjverde/sysgen

from formdin.