数据库常用操作，sql server; mysql

select top 10 * from customer order by sysno

mysql:    select * from customer order by sysno desc limit 10

 

select * from sys.extended_properties where major_id=object_id('customer')
SELECT * FROM fn_listextendedproperty('MS_Description', 'Schema', 'dbo', 'table', 'customer', 'column', default)