Web-automation.ru

Решение:

sp_columns 'as_menuRoles'

SELECT * FROM syscolumns sc
JOIN sysobjects so ON sc.id = so.id
WHERE so.Name = 'as_menuRoles'

select * from sysobjects so
WHERE so.Name = 'as_menuRoles'
------------
-- http://www.sql.ru/articles/mssql/03101301usingsqlservermetadata.shtml
SELECT * FROM mvccms.INFORMATION_SCHEMA.TABLES

SELECT *
FROM mvccms.INFORMATION_SCHEMA.columns
WHERE table_name = 'as_menuRoles'

SELECT COLUMNPROPERTY( OBJECT_ID('as_menuRoles'),'role','IsIdentity')

-- получить описание строки.
select
st.name [Table],
sc.name [Column],
sep.value [Description]
from sys.tables st
inner join sys.columns sc on st.object_id = sc.object_id
left join sys.extended_properties sep on st.object_id = sep.major_id
and sc.column_id = sep.minor_id
and sep.name = 'MS_Description'
where st.name = 'as_menuRoles'
and sc.name = 'role'

-- http://stackoverflow.com/questions/887370/sql-server-extract-table-meta-data-description-fields-and-their-data-types
SELECT u.name + '.' + t.name AS [table],
td.value AS [table_desc],
c.name AS [column],
cd.value AS [column_desc]
FROM sysobjects t
INNER JOIN sysusers u
ON u.uid = t.uid
LEFT OUTER JOIN sys.extended_properties td
ON td.major_id = t.id
AND td.minor_id = 0
AND td.name = 'MS_Description'
INNER JOIN syscolumns c
ON c.id = t.id
LEFT OUTER JOIN sys.extended_properties cd
ON cd.major_id = c.id
AND cd.minor_id = c.colid
AND cd.name = 'MS_Description'
WHERE t.type = 'u'
ORDER BY t.name, c.colorder

Периодически мы проводим обучение и даем возможность стажировки на базе нашей платформы с управлением на SQL. Если вам это интересно, то пожалуйста посмотрите информацию об обучении/стажировке по SQL.