SELECT * FROM sys.databases
SELECT * FROM sys.tables
select A.* ,'=========',B.* from sys.foreign_keys A
LEFT OUTER JOIN sys.foreign_key_columns B
ON A.referenced_object_id = B.referenced_object_id
where A.parent_object_id = OBJECT_ID(N'MakyoWeb.dbo.Board', N'U')
SELECT A.*,C.* FROM
(
SELECT 1 Code, name, referenced_object_id FROM sys.foreign_keys
where parent_object_id = OBJECT_ID(N'MakyoWeb.dbo.Board', N'U')
) A JOIN sys.foreign_key_columns B
ON A.referenced_object_id = B.referenced_object_id
JOIN sys.columns C
ON B.parent_object_id = object_id AND B.parent_column_id = C.column_id
SELECT A.object_id, A.name TableName, B.column_id ColumnID, B.name ColumnName, C.name ColumnTypeName
, C.name + CASE WHEN C.system_type_id in (167,175,231,239) THEN '(' + CONVERT(VARCHAR, B.max_length) + ')' ELSE '' END ColumnTypeNameDetail
, B.max_length ColumnSize, B.default_object_id, A.create_date CreateDate, A.modify_date UpdateDate FROM
sys.tables A JOIN sys.columns B
ON A.object_id = B.object_id
LEFT OUTER JOIN sys.types C
ON B.system_type_id = C.system_type_id AND B.user_type_id = C.user_type_id
-- type 정보
SELECT TYPEPROPERTY(SCHEMA_NAME(schema_id) + '.' + name, 'OwnerId') AS owner_id, name, system_type_id, user_type_id, schema_id
FROM sys.types;
SELECT OBJECT_ID(N'MakyoWeb.dbo.Board', N'U')
