首页 > 代码库 > MSSQL 查询表所有列

MSSQL 查询表所有列

SELECT name AS column_name,TYPE_NAME(system_type_id) AS column_type,max_length,is_nullableFROM sys.columnsWHERE object_id=OBJECT_ID(N‘functions‘)

  

MSSQL 查询表所有列