SELECT A.NAME AS TABLE_NAME, B.NAME AS USER_NAME FROM sysobjects A JOIN sysusers B ON A.UID = B.UID WHERE A.TYPE IN('U', 'IF', 'TF') ORDER BY A.TYPE, A.NAME ;
SELECT A.COLUMN_NAME, A.DATA_TYPE AS COLUMN_TYPE, A.CHARACTER_MAXIMUM_LENGTH, A.IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS AS A WHERE A.TABLE_SCHEMA = 'dbo' AND A.TABLE_NAME = [テーブル名] ORDER BY A.ORDINAL_POSITION ;
SELECT PARENT.name, PARENT.xtype, CHILD.name, CHILD.xtype FROM sysobjects AS PARENT JOIN sysobjects AS CHILD ON PARENT.id = CHILD.parent_obj ORDER BY PARENT.name ;
COPYRIGHT © 2008 Deepnet Inc. ALL RIGHTS RESERVED.