sp_help
sp_help tableName
SELECT column_name, data_type, is_nullable, character_maximum_length FROM information_schema.COLUMNS WHERE table_name='myTable'
select * from information_schema.COLUMNS WHERE table_name LIKE 'TABLENAME' select * from information_schema.KEY_COLUMN_USAGE select * from information_schema.TABLE_CONSTRAINTS IN ORACLE DESC TABLENAME
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)